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.PQP_NL_PENSION_EXTRACTS dependencies on PAY_ELEMENT_LINKS_F

Line 740: pay_element_links_f pelf,

736: ,pty.er_contribution_bal_type_id
737: FROM pay_element_type_extra_info pei,
738: pay_element_types_f pet,
739: pay_element_entries_f peef,
740: pay_element_links_f pelf,
741: pay_element_entry_values_f peev,
742: pay_input_values_f pivf,
743: pqp_pension_types_f pty
744: WHERE pei.information_type = 'PQP_NL_ABP_DEDUCTION'

Line 825: pay_element_links_f pelf,

821: ,pty.er_contribution_bal_type_id
822: FROM pay_element_type_extra_info pei,
823: pay_element_types_f pet,
824: pay_element_entries_f peef,
825: pay_element_links_f pelf,
826: pay_element_entry_values_f peev,
827: pay_input_values_f pivf,
828: pqp_pension_types_f pty
829: WHERE pei.information_type = 'PQP_NL_ABP_DEDUCTION'

Line 1062: pay_element_links_f pelf,

1058: SELECT to_date('1/'||to_char(pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id),'MM/YYYY'),'DD/MM/YYYY') start_date
1059: ,add_months(to_date('1/'||to_char(pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id),'MM/YYYY'),'DD/MM/YYYY'),1) - 1 end_date
1060: ,fnd_number.canonical_to_number(peev.screen_entry_value) ptp
1061: FROM pay_element_entries_f peef,
1062: pay_element_links_f pelf,
1063: pay_element_entry_values_f peev
1064: WHERE c_effective_date BETWEEN peef.effective_start_date AND
1065: peef.effective_end_date
1066: AND c_effective_date BETWEEN pelf.effective_start_date AND

Line 1088: pay_element_links_f pelf,

1084: ,c_input_val_id IN NUMBER ) IS
1085:
1086: SELECT 1
1087: FROM pay_element_entries_f peef,
1088: pay_element_links_f pelf,
1089: pay_element_entry_values_f peev
1090: WHERE c_effective_date BETWEEN peef.effective_start_date AND
1091: peef.effective_end_date
1092: AND c_effective_date BETWEEN pelf.effective_start_date AND

Line 1118: pay_element_links_f pelf,

1114: SELECT to_date('1/'||to_char(ppa.date_earned,'MM/YYYY'),'DD/MM/YYYY') start_date
1115: ,add_months(to_date('1/'||to_char(ppa.date_earned,'MM/YYYY'),'DD/MM/YYYY'),1) - 1 end_date
1116: ,fnd_number.canonical_to_number(prrv.result_value) ptp, 'Y' Yes
1117: FROM pay_element_entries_f peef,
1118: pay_element_links_f pelf,
1119: pay_element_entry_values_f peev,
1120: pay_run_results prr,
1121: pay_run_result_values prrv,
1122: pay_assignment_actions paa,

Line 2847: pay_element_links_f pelf

2843: --
2844: CURSOR c_abp_entry IS
2845: SELECT 1
2846: FROM pay_element_entries_f peef,
2847: pay_element_links_f pelf
2848: WHERE p_effective_date BETWEEN peef.effective_start_date AND
2849: peef.effective_end_date
2850: AND p_effective_date BETWEEN pelf.effective_start_date AND
2851: pelf.effective_end_date

Line 3223: pay_element_links_f pelf,

3219: ,c_ele_type_id IN NUMBER
3220: ,c_input_val_id IN NUMBER ) IS
3221: SELECT NVL(sum(round(fnd_number.canonical_to_number(peev.screen_entry_value),2)),0) prior_ptp
3222: FROM pay_element_entries_f peef,
3223: pay_element_links_f pelf,
3224: pay_element_entry_values_f peev
3225: WHERE peef.effective_start_date < c_effective_date
3226: AND c_effective_date BETWEEN pelf.effective_start_date AND
3227: pelf.effective_end_date