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_PAYWSMEE_PKG

Line 730: ,pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id) date_earned

726: CURSOR c_rec_12_ele( c_bg_id IN Number
727: ,c_effective_date IN Date
728: ,c_asg_id IN Number) IS
729: SELECT pei.eei_information12 sub_cat
730: ,pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id) date_earned
731: ,Decode (pei.eei_information12,'OPNP_65',5,'OPNP_W25',6,'OPNP_W50',7,
732: 'VSG',9,'FPU_E',4,'FPU_R',2,'FPU_S',1,'FPU_T',3,'FPU_B',1
733: ,'PPP',11) code
734: ,sum(fnd_number.canonical_to_number(peev.screen_entry_value)) amount

Line 790: GROUP BY pei.eei_information12,pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id)

786: AND peef.assignment_id = c_asg_id
787: AND pei.EEI_INFORMATION12 IN ('OPNP_65','OPNP_W25','OPNP_W50','PPP','FPU_B',
788: 'VSG','FPU_E','FPU_R','FPU_S','FPU_T')
789: AND pty.pension_type_id = to_number(pei.eei_information2)
790: GROUP BY pei.eei_information12,pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id)
791: ,pty.ee_contribution_bal_type_id,pty.er_contribution_bal_type_id
792: UNION
793: SELECT pension_sub_category sub_cat
794: ,c_effective_date date_earned

Line 817: ,pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id) date_earned

813: CURSOR c_contrib_rec_41_ele( c_bg_id IN Number
814: ,c_effective_date IN Date
815: ,c_asg_id IN Number) IS
816: SELECT pei.eei_information12 sub_cat
817: ,pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id) date_earned
818: ,9 code
819: ,sum(fnd_number.canonical_to_number(peev.screen_entry_value)) amount
820: ,pty.ee_contribution_bal_type_id
821: ,pty.er_contribution_bal_type_id

Line 859: GROUP BY pei.eei_information12,pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id)

855: AND pet.business_group_id = c_bg_id
856: AND peef.assignment_id = c_asg_id
857: AND pei.EEI_INFORMATION12 IN ('FUR_S')
858: AND pty.pension_type_id = to_number(pei.eei_information2)
859: GROUP BY pei.eei_information12,pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id)
860: ,pty.ee_contribution_bal_type_id,pty.er_contribution_bal_type_id
861: UNION
862: SELECT pension_sub_category sub_cat
863: ,c_effective_date date_earned

Line 1003: AND pay_paywsmee_pkg.get_original_date_earned(c_element_entry_id)

999: FROM per_time_periods ptp
1000: ,per_all_assignments_f paa
1001: WHERE paa.assignment_id = c_assignment_id
1002: AND ptp.payroll_id = paa.payroll_id
1003: AND pay_paywsmee_pkg.get_original_date_earned(c_element_entry_id)
1004: BETWEEN paa.effective_start_date
1005: AND paa.effective_end_date
1006: AND pay_paywsmee_pkg.get_original_date_earned(c_element_entry_id)
1007: BETWEEN ptp.start_date

Line 1006: AND pay_paywsmee_pkg.get_original_date_earned(c_element_entry_id)

1002: AND ptp.payroll_id = paa.payroll_id
1003: AND pay_paywsmee_pkg.get_original_date_earned(c_element_entry_id)
1004: BETWEEN paa.effective_start_date
1005: AND paa.effective_end_date
1006: AND pay_paywsmee_pkg.get_original_date_earned(c_element_entry_id)
1007: BETWEEN ptp.start_date
1008: AND ptp.end_date;
1009:
1010: -- ============================================================================

Line 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

1054: ,c_effective_date IN DATE
1055: ,c_ele_type_id IN NUMBER
1056: ,c_input_val_id IN NUMBER ) IS
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,

Line 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

1055: ,c_ele_type_id IN NUMBER
1056: ,c_input_val_id IN NUMBER ) IS
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

Line 1153: trunc(pay_paywsmee_pkg.get_original_date_earned(c_element_entry_id))

1149: -- Cursor to get the original date earned for a retro element entry
1150: -- ============================================================================
1151: CURSOR c_get_retro_date_earned(c_element_entry_id in number) IS
1152: SELECT substr(fnd_date.date_to_canonical(
1153: trunc(pay_paywsmee_pkg.get_original_date_earned(c_element_entry_id))
1154: ),1,10)
1155: FROM dual;
1156:
1157: TYPE r_rec_retro_ptp IS RECORD

Line 3235: AND pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id)

3231: AND pelf.element_type_id = c_ele_type_id
3232: AND peev.input_value_id = c_input_val_id
3233: AND peef.assignment_id = c_asg_id
3234: AND peev.screen_entry_value IS NOT NULL
3235: AND pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id)
3236: BETWEEN c_orig_st_date AND c_orig_ed_date;
3237:
3238: CURSOR c_sent_to_abp (c_eff_dt IN DATE) IS
3239: SELECT 1

Line 4106: pay_paywsmee_pkg.get_original_date_earned(

4102:
4103: l_retro_age_cal_dt :=
4104: fnd_date.canonical_to_date(substr(substr(
4105: fnd_date.date_to_canonical(
4106: pay_paywsmee_pkg.get_original_date_earned(
4107: temp_rec.element_entry_id)),1,10),1,8)||'01');
4108:
4109:
4110: IF l_retro_ptp_value <> 0 AND chk_subcat_disp (l_rec_09(i).code

Line 4158: pay_paywsmee_pkg.get_original_date_earned(

4154:
4155: l_retro_age_cal_dt :=
4156: fnd_date.canonical_to_date(substr(substr(
4157: fnd_date.date_to_canonical(
4158: pay_paywsmee_pkg.get_original_date_earned(
4159: temp_rec.element_entry_id)),1,10),1,8)||'01');
4160:
4161: l_ee_age_at_retro := Get_Age(
4162: p_assignment_id

Line 4220: pay_paywsmee_pkg.get_original_date_earned(

4216:
4217: l_retro_age_cal_dt :=
4218: fnd_date.canonical_to_date(substr(substr(
4219: fnd_date.date_to_canonical(
4220: pay_paywsmee_pkg.get_original_date_earned(
4221: temp_rec.element_entry_id)),1,10),1,8)||'01');
4222:
4223: l_ee_age_at_retro := Get_Age(
4224: p_assignment_id

Line 4609: pay_paywsmee_pkg.get_original_date_earned(

4605: l_rec_31_disp := 'Y';
4606: l_rec_31_values(k).processed := 'N';
4607: l_rec_31_values(k).code := l_rec_31(i).code;
4608: l_rec_31_values(k).date_earned := substr(fnd_date.date_to_canonical(
4609: pay_paywsmee_pkg.get_original_date_earned(
4610: temp_rec.element_entry_id)
4611: ),1,10);
4612:
4613: IF l_rec_31_values(k).basis_amount < 0 THEN

Line 4647: pay_paywsmee_pkg.get_original_date_earned(

4643: l_rec_31_values(k).processed := 'N';
4644: l_rec_31_values(k).code := l_rec_31(i).code;
4645: l_rec_31_values(k).date_earned := ' ';
4646: l_rec_31_values(k).date_earned := substr(fnd_date.date_to_canonical(
4647: pay_paywsmee_pkg.get_original_date_earned(
4648: temp_rec.element_entry_id)
4649: ),1,10);
4650:
4651: IF l_rec_31_values(k).basis_amount < 0 THEN

Line 4724: pay_paywsmee_pkg.get_original_date_earned(

4720: l_basis_rec_41_disp := 'Y';
4721: l_rec_41_basis_values(k).processed := 'N';
4722: l_rec_41_basis_values(k).code := l_basis_rec_41(i).code;
4723: l_rec_41_basis_values(k).date_earned := substr(fnd_date.date_to_canonical(
4724: pay_paywsmee_pkg.get_original_date_earned(
4725: temp_rec.element_entry_id)
4726: ),1,10);
4727:
4728: IF l_rec_41_basis_values(k).basis_amount < 0 THEN

Line 4762: pay_paywsmee_pkg.get_original_date_earned(

4758: l_rec_41_basis_values(k).processed := 'N';
4759: l_rec_41_basis_values(k).code := l_basis_rec_41(i).code;
4760: l_rec_41_basis_values(k).date_earned := ' ';
4761: l_rec_41_basis_values(k).date_earned := substr(fnd_date.date_to_canonical(
4762: pay_paywsmee_pkg.get_original_date_earned(
4763: temp_rec.element_entry_id)
4764: ),1,10);
4765:
4766: IF l_rec_41_basis_values(k).basis_amount < 0 THEN