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_ENTRIES_F

Line 739: pay_element_entries_f peef,

735: ,pty.ee_contribution_bal_type_id
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

Line 824: pay_element_entries_f peef,

820: ,pty.ee_contribution_bal_type_id
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

Line 1061: FROM pay_element_entries_f peef,

1057:
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

Line 1087: FROM pay_element_entries_f peef,

1083: ,c_ele_type_id IN NUMBER
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

Line 1117: FROM pay_element_entries_f peef,

1113:
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,

Line 2846: FROM pay_element_entries_f peef,

2842: -- exists for the EE assignment
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

Line 3222: FROM pay_element_entries_f peef,

3218: ,c_orig_ed_date IN DATE
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