APPS.PQP_GB_AD_EE dependencies on PAY_ELEMENT_TYPES_F

Line 142: pay_element_types_f pet,

138: SELECT count(asg.assignment_id)
139: INTO l_asg_count
140: FROM pay_element_links_f pel,
141: pay_element_entries_f pee,
142: pay_element_types_f pet,
143: per_all_assignments_f asg,
144: pay_element_type_extra_info pete,
145: pay_element_entry_values_f peev,
146: pay_input_values_f piv

Line 235: pay_element_types_f pet,

231: pel.effective_end_date link_end_date,
232: pee.effective_start_date
233: FROM pay_element_links_f pel,
234: pay_element_entries_f pee,
235: pay_element_types_f pet,
236: pay_element_type_extra_info pete
237: WHERE pet.element_type_id = pel.element_type_id
238: AND pel.element_link_id = pee.element_link_id
239: AND pet.element_type_id = pete.element_type_id

Line 260: pay_element_types_f pet,

256: CURSOR chk_cur IS
257: SELECT 'x'
258: FROM pay_element_links_f pel,
259: pay_element_entries_f pee,
260: pay_element_types_f pet,
261: pay_element_type_extra_info pete
262: WHERE pet.element_type_id = pel.element_type_id
263: AND pel.element_link_id = pee.element_link_id
264: AND pet.element_type_id = pete.element_type_id

Line 285: pay_element_types_f pet,

281: ) IS
282: SELECT peev.screen_entry_value
283: FROM pay_element_links_f pel,
284: pay_element_entries_f pee,
285: pay_element_types_f pet,
286: pay_element_type_extra_info pete,
287: pay_element_entry_values_f peev,
288: pay_input_values_f piv
289: WHERE pet.element_type_id = pel.element_type_id

Line 318: pay_element_types_f pet,

314: ) IS
315: SELECT peev.screen_entry_value
316: FROM pay_element_links_f pel,
317: pay_element_entries_f pee,
318: pay_element_types_f pet,
319: pay_element_type_extra_info pete,
320: pay_element_entry_values_f peev,
321: pay_input_values_f piv
322: WHERE pet.element_type_id = pel.element_type_id

Line 355: pay_element_types_f pet,

351: ,p_in_end_date IN DATE) IS
352: SELECT peev.screen_entry_value
353: FROM pay_element_links_f pel,
354: pay_element_entries_f pee,
355: pay_element_types_f pet,
356: pay_element_type_extra_info pete,
357: pay_element_entry_values_f peev,
358: pay_input_values_f piv
359: WHERE pet.element_type_id = pel.element_type_id

Line 388: pay_element_types_f pet,

384: ,p_in_end_date IN DATE) IS
385: SELECT peev.screen_entry_value
386: FROM pay_element_links_f pel,
387: pay_element_entries_f pee,
388: pay_element_types_f pet,
389: pay_element_type_extra_info pete,
390: pay_element_entry_values_f peev,
391: pay_input_values_f piv
392: WHERE pet.element_type_id = pel.element_type_id

Line 743: FROM pay_element_types_f_tl elementtl,

739:
740: CURSOR c_element_details
741: IS
742: SELECT element.element_type_id , link.element_link_id,element.business_group_id
743: FROM pay_element_types_f_tl elementtl,
744: pay_element_types_f element,
745: pay_element_links_f link,
746: per_all_assignments_f asgt ,
747: per_periods_of_service service_period

Line 744: pay_element_types_f element,

740: CURSOR c_element_details
741: IS
742: SELECT element.element_type_id , link.element_link_id,element.business_group_id
743: FROM pay_element_types_f_tl elementtl,
744: pay_element_types_f element,
745: pay_element_links_f link,
746: per_all_assignments_f asgt ,
747: per_periods_of_service service_period
748: WHERE

Line 1534: FROM pay_element_types_f

1530:
1531: CURSOR csr_get_element
1532: IS
1533: SELECT element_name
1534: FROM pay_element_types_f
1535: WHERE element_type_id = p_element_type_id
1536: AND p_effective_start_date BETWEEN effective_start_date AND effective_end_date
1537: AND legislation_code = 'GB';
1538:

Line 1554: l_element_name pay_element_types_f.element_name%TYPE;

1550: AND piv.name in ('Type','Reference')
1551: AND piv.legislation_code = 'GB'
1552: ORDER BY piv.name DESC;
1553:
1554: l_element_name pay_element_types_f.element_name%TYPE;
1555: l_type pay_element_entry_values_f.screen_entry_value%TYPE;
1556: l_reference pay_element_entry_values_f.screen_entry_value%TYPE;
1557:
1558: BEGIN

Line 1623: FROM pay_element_types_f

1619:
1620: CURSOR csr_get_element
1621: IS
1622: SELECT element_name
1623: FROM pay_element_types_f
1624: WHERE element_type_id = p_element_type_id_o
1625: AND p_effective_date BETWEEN effective_start_date AND effective_end_date
1626: AND legislation_code = 'GB';
1627:

Line 1696: l_element_name pay_element_types_f.element_name%TYPE;

1692: FROM pay_run_results prr2
1693: WHERE prr2.source_id = PRR.run_result_id
1694: AND prr2.source_type IN ('R', 'V'));
1695:
1696: l_element_name pay_element_types_f.element_name%TYPE;
1697: l_type pay_element_entry_values_f.screen_entry_value%TYPE;
1698: l_reference pay_element_entry_values_f.screen_entry_value%TYPE;
1699:
1700: v_exists VARCHAR2(100) := 'N';