APPS.HR_ENTRY_API dependencies on PAY_ELEMENT_LINKS_F

Line 2166: pay_element_links_f el

2162: begin
2163: select el.element_link_id
2164: into v_element_link_id
2165: from per_assignments_f asg,
2166: pay_element_links_f el
2167: where asg.assignment_id = p_assignment_id
2168: and el.business_group_id + 0 = asg.business_group_id + 0
2169: and el.element_type_id = p_element_type_id
2170: and p_session_date between asg.effective_start_date

Line 2238: pay_element_links_f eli

2234: --
2235: cursor third_party_element is
2236: select 1
2237: from pay_element_types_f elt,
2238: pay_element_links_f eli
2239: where eli.element_link_id = p_element_link_id
2240: and eli.element_type_id = elt.element_type_id
2241: and p_effective_start_date <= eli.effective_end_date
2242: and p_effective_end_date >= eli.effective_start_date

Line 2338: pay_element_links_f ELI

2334: --
2335: cursor processing_type is
2336: select 1
2337: from pay_element_types_f ELT,
2338: pay_element_links_f ELI
2339: where eli.element_link_id = p_element_link_id
2340: and eli.element_type_id = elt.element_type_id
2341: and p_effective_start_date <= eli.effective_end_date
2342: and p_effective_end_date >= eli.effective_start_date

Line 2457: from pay_element_links_f el

2453: begin
2454: --
2455: select el.element_link_id
2456: into v_number_variable
2457: from pay_element_links_f el
2458: where el.element_link_id = p_element_link_id
2459: and p_validation_start_date between el.effective_start_date
2460: and el.effective_end_date;
2461: --

Line 2602: from pay_element_links_f el,

2598: and ee.element_link_id = p_element_link_id
2599: and ee.entry_type = 'E'
2600: and exists
2601: (select null
2602: from pay_element_links_f el,
2603: pay_element_types_f et
2604: where el.element_link_id = p_element_link_id
2605: and et.element_type_id = el.element_type_id
2606: and et.processing_type = 'R')

Line 2658: ,pay_element_links_f el

2654: cursor csr_adj_orig_entry
2655: is
2656: select 1
2657: from pay_element_entries_f ee
2658: ,pay_element_links_f el
2659: ,pay_element_types_f et
2660: where ee.assignment_id = p_assignment_id
2661: and nvl(ee.original_entry_id, ee.element_entry_id)
2662: = p_original_entry_id

Line 2704: ,pay_element_links_f el

2700: from sys.dual
2701: where exists
2702: (select null
2703: from pay_element_entries_f ee
2704: ,pay_element_links_f el
2705: ,pay_element_types_f et
2706: where ee.assignment_id = p_assignment_id
2707: /*Bug fix 12364433 */
2708: /*and ee.element_link_id = p_element_link_id*/

Line 2811: from pay_element_links_f

2807: --
2808: BEGIN
2809: select element_type_id
2810: into l_ele_type_id
2811: from pay_element_links_f
2812: where element_link_id = p_element_link_id
2813: and p_effective_date between effective_start_date
2814: and effective_end_date;
2815: --

Line 5506: pay_element_links_f el,

5502: decode(p_entry_information29,hr_api.g_varchar2,ee.entry_information29,p_entry_information29),
5503: decode(p_entry_information30,hr_api.g_varchar2,ee.entry_information30,p_entry_information30)
5504: into v_entry_rec
5505: from pay_element_entries_f ee,
5506: pay_element_links_f el,
5507: pay_element_types_f et
5508: where ee.element_entry_id = p_element_entry_id
5509: and el.element_link_id = ee.element_link_id
5510: and et.element_type_id = el.element_type_id

Line 8007: pay_element_links_f el,

8003: nvl(ec.non_payments_flag, 'N'),
8004: ee.personal_payment_method_id
8005: into v_entry_rec
8006: from pay_element_entries_f ee,
8007: pay_element_links_f el,
8008: pay_element_types_f et,
8009: pay_element_classifications ec
8010: where ee.element_entry_id = p_element_entry_id
8011: and el.element_link_id = ee.element_link_id