APPS.HR_ENTRY_API dependencies on PAY_ELEMENT_LINKS_F

Line 2164: pay_element_links_f el

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

Line 2236: pay_element_links_f eli

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

Line 2336: pay_element_links_f ELI

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

Line 2455: from pay_element_links_f el

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

Line 2600: from pay_element_links_f el,

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

Line 2656: ,pay_element_links_f el

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

Line 2702: ,pay_element_links_f el

2698: from sys.dual
2699: where exists
2700: (select null
2701: from pay_element_entries_f ee
2702: ,pay_element_links_f el
2703: ,pay_element_types_f et
2704: where ee.assignment_id = p_assignment_id
2705: and ee.element_link_id = p_element_link_id
2706: and ee.element_entry_id = p_original_entry_id

Line 2808: from pay_element_links_f

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

Line 5503: pay_element_links_f el,

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

Line 7991: pay_element_links_f el,

7987: nvl(ec.non_payments_flag, 'N'),
7988: ee.personal_payment_method_id
7989: into v_entry_rec
7990: from pay_element_entries_f ee,
7991: pay_element_links_f el,
7992: pay_element_types_f et,
7993: pay_element_classifications ec
7994: where ee.element_entry_id = p_element_entry_id
7995: and el.element_link_id = ee.element_link_id