APPS.HR_COST dependencies on PAY_ELEMENT_ENTRIES_F

Line 37: g_element_entry_id pay_element_entries_f.source_id%type := -1;

33: mwcallag 15-MAR-1993 - close cursor dist_rrv added
34: mwcallag 03-MAR-1993 - created.
35: */
36: -- Cache for get_rr_date
37: g_element_entry_id pay_element_entries_f.source_id%type := -1;
38: g_creator_type pay_element_entries_f.creator_type%type;
39: /*----------------------------- cost_bal_adj ---------------------------------*/
40: /*
41: NAME

Line 38: g_creator_type pay_element_entries_f.creator_type%type;

34: mwcallag 03-MAR-1993 - created.
35: */
36: -- Cache for get_rr_date
37: g_element_entry_id pay_element_entries_f.source_id%type := -1;
38: g_creator_type pay_element_entries_f.creator_type%type;
39: /*----------------------------- cost_bal_adj ---------------------------------*/
40: /*
41: NAME
42: cost_bal_adj - return whether a balance adjustment result should be

Line 60: from pay_element_entries_f ee

56: BEGIN
57:
58: select nvl(ee.balance_adj_cost_flag, 'N')
59: into cost_ba
60: from pay_element_entries_f ee
61: where ee.element_entry_id = p_element_entry_id
62: and p_baladj_date between ee.effective_start_date
63: and ee.effective_end_date;
64:

Line 129: l_creator_type pay_element_entries_f.creator_type%type;

125: p_date_earned in date
126: ) return date is
127: res_date date;
128: l_start_date date;
129: l_creator_type pay_element_entries_f.creator_type%type;
130: --
131: BEGIN
132:
133: res_date := p_end_date;

Line 149: from pay_element_entries_f

145: g_creator_type := 'E';
146:
147: select creator_type
148: into l_creator_type
149: from pay_element_entries_f
150: where element_entry_id = p_source_id
151: and rownum = 1;
152:
153: if (l_creator_type in ('RR', 'EE', 'NR', 'PR')) then

Line 193: l_creator_type pay_element_entries_f.creator_type%type;

189: p_date_earned in date
190: ) return date is
191: res_date date;
192: l_end_date date;
193: l_creator_type pay_element_entries_f.creator_type%type;
194: --
195: BEGIN
196:
197: res_date := p_end_date;

Line 244: from pay_element_entries_f

240: g_creator_type := 'E';
241:
242: select creator_type
243: into l_creator_type
244: from pay_element_entries_f
245: where element_entry_id = p_source_id
246: and rownum = 1;
247:
248: if (l_creator_type in ('RR', 'EE', 'NR', 'PR')) then