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 758: pay_element_entries_f peef,

754: ,pty.ee_contribution_bal_type_id
755: ,pty.er_contribution_bal_type_id
756: FROM pay_element_type_extra_info pei,
757: pay_element_types_f pet,
758: pay_element_entries_f peef,
759: pay_element_links_f pelf,
760: pay_element_entry_values_f peev,
761: pay_input_values_f pivf,
762: pqp_pension_types_f pty

Line 843: pay_element_entries_f peef,

839: ,pty.ee_contribution_bal_type_id
840: ,pty.er_contribution_bal_type_id
841: FROM pay_element_type_extra_info pei,
842: pay_element_types_f pet,
843: pay_element_entries_f peef,
844: pay_element_links_f pelf,
845: pay_element_entry_values_f peev,
846: pay_input_values_f pivf,
847: pqp_pension_types_f pty

Line 1080: FROM pay_element_entries_f peef,

1076:
1077: SELECT to_date('1/'||to_char(pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id),'MM/YYYY'),'DD/MM/YYYY') start_date
1078: ,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
1079: ,fnd_number.canonical_to_number(peev.screen_entry_value) ptp
1080: FROM pay_element_entries_f peef,
1081: pay_element_links_f pelf,
1082: pay_element_entry_values_f peev
1083: WHERE c_effective_date BETWEEN peef.effective_start_date AND
1084: peef.effective_end_date

Line 1106: FROM pay_element_entries_f peef,

1102: ,c_ele_type_id IN NUMBER
1103: ,c_input_val_id IN NUMBER ) IS
1104:
1105: SELECT 1
1106: FROM pay_element_entries_f peef,
1107: pay_element_links_f pelf,
1108: pay_element_entry_values_f peev
1109: WHERE c_effective_date BETWEEN peef.effective_start_date AND
1110: peef.effective_end_date

Line 1136: FROM pay_element_entries_f peef,

1132:
1133: SELECT to_date('1/'||to_char(ppa.date_earned,'MM/YYYY'),'DD/MM/YYYY') start_date
1134: ,add_months(to_date('1/'||to_char(ppa.date_earned,'MM/YYYY'),'DD/MM/YYYY'),1) - 1 end_date
1135: ,fnd_number.canonical_to_number(prrv.result_value) ptp, 'Y' Yes
1136: FROM pay_element_entries_f peef,
1137: pay_element_links_f pelf,
1138: pay_element_entry_values_f peev,
1139: pay_run_results prr,
1140: pay_run_result_values prrv,

Line 2867: FROM pay_element_entries_f peef,

2863: -- exists for the EE assignment
2864: --
2865: CURSOR c_abp_entry IS
2866: SELECT 1
2867: FROM pay_element_entries_f peef,
2868: pay_element_links_f pelf
2869: WHERE p_effective_date BETWEEN peef.effective_start_date AND
2870: peef.effective_end_date
2871: AND p_effective_date BETWEEN pelf.effective_start_date AND

Line 3243: FROM pay_element_entries_f peef,

3239: ,c_orig_ed_date IN DATE
3240: ,c_ele_type_id IN NUMBER
3241: ,c_input_val_id IN NUMBER ) IS
3242: SELECT NVL(sum(round(fnd_number.canonical_to_number(peev.screen_entry_value),2)),0) prior_ptp
3243: FROM pay_element_entries_f peef,
3244: pay_element_links_f pelf,
3245: pay_element_entry_values_f peev
3246: WHERE peef.effective_start_date < c_effective_date
3247: AND c_effective_date BETWEEN pelf.effective_start_date AND

Line 3573: FROM pay_element_entries_f peef,

3569: AND p_effective_date between piv1.effective_start_date AND piv1.effective_end_date;
3570:
3571: CURSOR c_ude_rec05(p_effective_date date, p_ele_type_id number, p_start_dt_id number, p_end_dt_id number, p_asg_id number) IS
3572: SELECT fnd_date.canonical_to_date(peev.screen_entry_value) start_date, fnd_date.canonical_to_date(peev1.screen_entry_value) end_date
3573: FROM pay_element_entries_f peef,
3574: pay_element_links_f pelf,
3575: pay_element_entry_values_f peev,
3576: pay_element_entry_values_f peev1
3577: WHERE p_effective_date BETWEEN peef.effective_start_date AND

Line 3619: FROM pay_element_entries_f peef,

3615:
3616: SELECT
3617: MIN(to_date('1/'||to_char(pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id),'MM/YYYY'),'DD/MM/YYYY')) start_date,
3618: MAX(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
3619: FROM pay_element_entries_f peef,
3620: pay_element_links_f pelf,
3621: pay_element_entry_values_f peev
3622: WHERE c_effective_date BETWEEN peef.effective_start_date AND
3623: peef.effective_end_date

Line 5851: FROM pay_element_entries_f peef

5847:
5848: CURSOR c_ele_entries(p_asg_id NUMBER)
5849: IS
5850: SELECT 1
5851: FROM pay_element_entries_f peef
5852: where
5853: peef.Assignment_id = p_asg_id
5854: AND (g_extract_params(p_business_group_id).extract_start_date BETWEEN peef.EFFECTIVE_START_DATE AND peef.EFFECTIVE_END_DATE
5855: OR

Line 11240: ,pay_element_entries_f peef

11236: --13571541
11237: CURSOR c_rec05_curr_ptp_end_date IS
11238: SELECT 'Y'
11239: FROM pay_element_types_f petf
11240: ,pay_element_entries_f peef
11241: WHERE petf.element_name = 'ABP flex workers PTP End Date'
11242: AND petf.element_type_id = peef.element_type_id
11243: AND peef.assignment_id = p_assignment_id
11244: AND p_effective_date BETWEEN peef.effective_start_date