APPS.PAY_ELEMENT_EXTRACT_PKG dependencies on PAY_ELEMENT_TYPES_F_TL

Line 761: pay_element_types_f_tl pettl,

757: ,cp_effective_date in date) is
758: select pet.reporting_name,
759: prrv.result_value
760: from pay_element_types_f pet,
761: pay_element_types_f_tl pettl,
762: pay_input_values_f piv,
763: pay_run_result_values prrv,
764: pay_run_results prr,
765: pay_input_values_f_tl pivtl

Line 875: pay_element_types_f_tl pettl

871: ,cp_end_date in date
872: ) is
873: select distinct nvl(pettl.reporting_name,pettl.element_name)
874: from pay_element_types_f pet,
875: pay_element_types_f_tl pettl
876: where pet.classification_id = cp_element_classification_id
877: and cp_business_group_id = nvl(pet.business_group_id, cp_business_group_id)
878: and pet.element_name not like '%Special Features'
879: and pet.element_name not like '%Special Inputs'

Line 893: pay_element_types_f_tl pettl,

889: START */
890: UNION ALL
891: select distinct nvl(pettl.reporting_name,pettl.element_name)
892: from pay_element_types_f pet,
893: pay_element_types_f_tl pettl,
894: PAY_SUB_CLASSIFICATION_RULES_F scr,
895: pay_element_classifications pec
896: where scr.element_type_id = pet.element_type_id
897: and pec.classification_id = cp_element_classification_id

Line 934: pay_element_types_f_tl pettl

930: ) is
931: select distinct nvl(pettl.reporting_name,pettl.element_name)
932: from pay_element_type_rules petr,
933: pay_element_types_f pet,
934: pay_element_types_f_tl pettl
935: where pet.element_type_id = petr.element_type_id
936: and petr.element_set_id = cp_ele_set_id
937: and petr.include_or_exclude = 'I'
938: and pettl.language = userenv('LANG')

Line 945: pay_element_types_f_tl pettl1

941: and pet.effective_end_date >= cp_start_date
942: union all
943: select distinct nvl(pettl1.reporting_name,pettl1.element_name)
944: from pay_element_types_f pet1,
945: pay_element_types_f_tl pettl1
946: where cp_business_group_id = nvl(pet1.business_group_id, cp_business_group_id)
947: and pet1.classification_id in
948: (select classification_id
949: from pay_ele_classification_rules

Line 964: pay_element_types_f_tl pettl

960: and pet1.effective_end_date >= cp_start_date
961: minus
962: select distinct nvl(pettl.reporting_name,pettl.element_name)
963: from pay_element_type_rules petr,
964: pay_element_types_f_tl pettl
965: where pettl.element_type_id = petr.element_type_id
966: and petr.element_set_id = cp_ele_set_id
967: and petr.include_or_exclude = 'E'
968: and pettl.language = userenv('LANG')

Line 980: from pay_element_types_f_tl pettl

976: --August 2003
977:
978: cursor c_elements (cp_ele_type_id in number) is
979: select distinct nvl(pettl.reporting_name,pettl.element_name)
980: from pay_element_types_f_tl pettl
981: where pettl.element_type_id = cp_ele_type_id
982: and pettl.language = userenv('LANG');
983:
984: /*************************************************************

Line 1383: pay_element_types_f_tl pettl,

1379: prrv.result_value,
1380: prr.Status,
1381: prr.run_result_id
1382: from pay_element_types_f pet,
1383: pay_element_types_f_tl pettl,
1384: pay_input_values_f piv,
1385: pay_run_result_values prrv,
1386: pay_run_results prr,
1387: pay_input_values_f_tl pivtl,

Line 1420: pay_element_types_f_tl pettl,

1416: prrv.result_value,
1417: prr.Status,
1418: prr.run_result_id
1419: from pay_element_types_f pet,
1420: pay_element_types_f_tl pettl,
1421: pay_input_values_f piv,
1422: pay_run_result_values prrv,
1423: pay_run_results prr,
1424: pay_input_values_f_tl pivtl,