APPS.PAY_ELEMENT_EXTRACT_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 582: from pay_element_types_f pet1

578: where petr.element_set_id = cp_element_set_id
579: and petr.include_or_exclude = 'I'
580: union all
581: select pet1.element_type_id
582: from pay_element_types_f pet1
583: where pet1.classification_id in
584: (select classification_id
585: from pay_ele_classification_rules
586: where element_set_id = cp_element_set_id)

Line 751: from pay_element_types_f pet,

747: ,cp_element_type_id in number
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,

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 781: from pay_element_types_f pet1

777: where petr.element_set_id = cp_element_set_id
778: and petr.include_or_exclude = 'I'
779: union all
780: select pet1.element_type_id
781: from pay_element_types_f pet1
782: where pet1.classification_id in
783: (select classification_id
784: from pay_ele_classification_rules
785: where element_set_id = cp_element_set_id)

Line 803: from pay_element_types_f pet,

799: ,cp_element_type_id in number
800: ,cp_effective_date in date) is
801: select pet.reporting_name,
802: prrv.result_value
803: from pay_element_types_f pet,
804: pay_input_values_f piv,
805: pay_run_result_values prrv,
806: pay_run_results prr
807: where piv.name = 'Pay Value'

Line 827: from pay_element_types_f pet1

823: where petr.element_set_id = cp_element_set_id
824: and petr.include_or_exclude = 'I'
825: union all
826: select pet1.element_type_id
827: from pay_element_types_f pet1
828: where pet1.classification_id in
829: (select classification_id
830: from pay_ele_classification_rules
831: where element_set_id = cp_element_set_id)

Line 865: from pay_element_types_f pet,

861: ,cp_start_date in date
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'

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 883: from pay_element_types_f pet,

879: /* Added to fix Bug # 5167072
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

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 924: pay_element_types_f pet,

920: ,cp_end_date in date
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'

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 935: from pay_element_types_f pet1,

931: and pet.effective_start_date <= cp_end_date --bug # 5229191
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

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 1370: from pay_element_types_f pet,

1366: nvl(pet.reporting_name,pet.element_name),
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,

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 1409: from pay_element_types_f pet,

1405: nvl(pet.reporting_name,pet.element_name),
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,

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,