APPS.PAY_ELEMENT_EXTRACT_PKG dependencies on PAY_ELEMENT_TYPES_F_TL

Line 752: pay_element_types_f_tl pettl,

748: ,cp_effective_date in date) is
749: select pet.reporting_name,
750: prrv.result_value
751: from pay_element_types_f pet,
752: pay_element_types_f_tl pettl,
753: pay_input_values_f piv,
754: pay_run_result_values prrv,
755: pay_run_results prr,
756: pay_input_values_f_tl pivtl

Line 866: pay_element_types_f_tl pettl

862: ,cp_end_date in date
863: ) is
864: select distinct nvl(pettl.reporting_name,pettl.element_name)
865: from pay_element_types_f pet,
866: pay_element_types_f_tl pettl
867: where pet.classification_id = cp_element_classification_id
868: and cp_business_group_id = nvl(pet.business_group_id, cp_business_group_id)
869: and pet.element_name not like '%Special Features'
870: and pet.element_name not like '%Special Inputs'

Line 884: pay_element_types_f_tl pettl,

880: START */
881: UNION ALL
882: select distinct nvl(pettl.reporting_name,pettl.element_name)
883: from pay_element_types_f pet,
884: pay_element_types_f_tl pettl,
885: PAY_SUB_CLASSIFICATION_RULES_F scr,
886: pay_element_classifications pec
887: where scr.element_type_id = pet.element_type_id
888: and pec.classification_id = cp_element_classification_id

Line 925: pay_element_types_f_tl pettl

921: ) is
922: select distinct nvl(pettl.reporting_name,pettl.element_name)
923: from pay_element_type_rules petr,
924: pay_element_types_f pet,
925: pay_element_types_f_tl pettl
926: where pet.element_type_id = petr.element_type_id
927: and petr.element_set_id = cp_ele_set_id
928: and petr.include_or_exclude = 'I'
929: and pettl.language = userenv('LANG')

Line 936: pay_element_types_f_tl pettl1

932: and pet.effective_end_date >= cp_start_date
933: union all
934: select distinct nvl(pettl1.reporting_name,pettl1.element_name)
935: from pay_element_types_f pet1,
936: pay_element_types_f_tl pettl1
937: where cp_business_group_id = nvl(pet1.business_group_id, cp_business_group_id)
938: and pet1.classification_id in
939: (select classification_id
940: from pay_ele_classification_rules

Line 955: pay_element_types_f_tl pettl

951: and pet1.effective_end_date >= cp_start_date
952: minus
953: select distinct nvl(pettl.reporting_name,pettl.element_name)
954: from pay_element_type_rules petr,
955: pay_element_types_f_tl pettl
956: where pettl.element_type_id = petr.element_type_id
957: and petr.element_set_id = cp_ele_set_id
958: and petr.include_or_exclude = 'E'
959: and pettl.language = userenv('LANG')

Line 971: from pay_element_types_f_tl pettl

967: --August 2003
968:
969: cursor c_elements (cp_ele_type_id in number) is
970: select distinct nvl(pettl.reporting_name,pettl.element_name)
971: from pay_element_types_f_tl pettl
972: where pettl.element_type_id = cp_ele_type_id
973: and pettl.language = userenv('LANG');
974:
975: /*************************************************************

Line 1371: pay_element_types_f_tl pettl,

1367: prrv.result_value,
1368: prr.Status,
1369: decode(prr.entry_type,''E'',decode(pet.multiple_entries_allowed_flag,''Y'',prr.run_result_id,-1),prr.run_result_id) run_result_id
1370: from pay_element_types_f pet,
1371: pay_element_types_f_tl pettl,
1372: pay_input_values_f piv,
1373: pay_run_result_values prrv,
1374: pay_run_results prr,
1375: pay_input_values_f_tl pivtl,

Line 1410: pay_element_types_f_tl pettl,

1406: prrv.result_value,
1407: prr.Status,
1408: decode(prr.entry_type,''E'',decode(pet.multiple_entries_allowed_flag,''Y'',prr.run_result_id,-1),prr.run_result_id) run_result_id
1409: from pay_element_types_f pet,
1410: pay_element_types_f_tl pettl,
1411: pay_input_values_f piv,
1412: pay_run_result_values prrv,
1413: pay_run_results prr,
1414: pay_input_values_f_tl pivtl,