eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ELEMENT_EXTRACT_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 591: from pay_element_types_f pet1

587: where petr.element_set_id = cp_element_set_id
588: and petr.include_or_exclude = 'I'
589: union all
590: select pet1.element_type_id
591: from pay_element_types_f pet1
592: where pet1.classification_id in
593: (select classification_id
594: from pay_ele_classification_rules
595: where element_set_id = cp_element_set_id)

Line 760: from pay_element_types_f pet,

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

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

786: where petr.element_set_id = cp_element_set_id
787: and petr.include_or_exclude = 'I'
788: union all
789: select pet1.element_type_id
790: from pay_element_types_f pet1
791: where pet1.classification_id in
792: (select classification_id
793: from pay_ele_classification_rules
794: where element_set_id = cp_element_set_id)

Line 812: from pay_element_types_f pet,

808: ,cp_element_type_id in number
809: ,cp_effective_date in date) is
810: select pet.reporting_name,
811: prrv.result_value
812: from pay_element_types_f pet,
813: pay_input_values_f piv,
814: pay_run_result_values prrv,
815: pay_run_results prr
816: where piv.name = 'Pay Value'

Line 836: from pay_element_types_f pet1

832: where petr.element_set_id = cp_element_set_id
833: and petr.include_or_exclude = 'I'
834: union all
835: select pet1.element_type_id
836: from pay_element_types_f pet1
837: where pet1.classification_id in
838: (select classification_id
839: from pay_ele_classification_rules
840: where element_set_id = cp_element_set_id)

Line 874: from pay_element_types_f pet,

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

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

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

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

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

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

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

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

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

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

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

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,