APPS.HR_COST dependencies on PAY_ELEMENT_ENTRIES_F

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

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

Line 37: g_creator_type pay_element_entries_f.creator_type%type;

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

Line 59: from pay_element_entries_f ee

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

Line 128: l_creator_type pay_element_entries_f.creator_type%type;

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

Line 148: from pay_element_entries_f

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

Line 192: l_creator_type pay_element_entries_f.creator_type%type;

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

Line 243: from pay_element_entries_f

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