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 749: ,pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id) date_earned

745: CURSOR c_rec_12_ele( c_bg_id IN Number
746: ,c_effective_date IN Date
747: ,c_asg_id IN Number) IS
748: SELECT pei.eei_information12 sub_cat
749: ,pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id) date_earned
750: ,Decode (pei.eei_information12,'OPNP_65',5,'OPNP_W25',6,'OPNP_W50',7,
751: 'VSG',9,'FPU_E',4,'FPU_R',2,'FPU_S',1,'FPU_T',3,'FPU_B',1
752: ,'PPP',11) code
753: ,sum(fnd_number.canonical_to_number(peev.screen_entry_value)) amount

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

805: AND peef.assignment_id = c_asg_id
806: AND pei.EEI_INFORMATION12 IN ('OPNP_65','OPNP_W25','OPNP_W50','PPP','FPU_B',
807: 'VSG','FPU_E','FPU_R','FPU_S','FPU_T')
808: AND pty.pension_type_id = to_number(pei.eei_information2)
809: GROUP BY pei.eei_information12,pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id)
810: ,pty.ee_contribution_bal_type_id,pty.er_contribution_bal_type_id
811: UNION
812: SELECT pension_sub_category sub_cat
813: ,c_effective_date date_earned

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

832: CURSOR c_contrib_rec_41_ele( c_bg_id IN Number
833: ,c_effective_date IN Date
834: ,c_asg_id IN Number) IS
835: SELECT pei.eei_information12 sub_cat
836: ,pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id) date_earned
837: ,9 code
838: ,sum(fnd_number.canonical_to_number(peev.screen_entry_value)) amount
839: ,pty.ee_contribution_bal_type_id
840: ,pty.er_contribution_bal_type_id

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

874: AND pet.business_group_id = c_bg_id
875: AND peef.assignment_id = c_asg_id
876: AND pei.EEI_INFORMATION12 IN ('FUR_S')
877: AND pty.pension_type_id = to_number(pei.eei_information2)
878: GROUP BY pei.eei_information12,pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id)
879: ,pty.ee_contribution_bal_type_id,pty.er_contribution_bal_type_id
880: UNION
881: SELECT pension_sub_category sub_cat
882: ,c_effective_date date_earned

Line 1022: AND pay_paywsmee_pkg.get_original_date_earned(c_element_entry_id)

1018: FROM per_time_periods ptp
1019: ,per_all_assignments_f paa
1020: WHERE paa.assignment_id = c_assignment_id
1021: AND ptp.payroll_id = paa.payroll_id
1022: AND pay_paywsmee_pkg.get_original_date_earned(c_element_entry_id)
1023: BETWEEN paa.effective_start_date
1024: AND paa.effective_end_date
1025: AND pay_paywsmee_pkg.get_original_date_earned(c_element_entry_id)
1026: BETWEEN ptp.start_date

Line 1025: AND pay_paywsmee_pkg.get_original_date_earned(c_element_entry_id)

1021: AND ptp.payroll_id = paa.payroll_id
1022: AND pay_paywsmee_pkg.get_original_date_earned(c_element_entry_id)
1023: BETWEEN paa.effective_start_date
1024: AND paa.effective_end_date
1025: AND pay_paywsmee_pkg.get_original_date_earned(c_element_entry_id)
1026: BETWEEN ptp.start_date
1027: AND ptp.end_date;
1028:
1029: -- ============================================================================

Line 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

1073: ,c_effective_date IN DATE
1074: ,c_ele_type_id IN NUMBER
1075: ,c_input_val_id IN NUMBER ) IS
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,

Line 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

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

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

1168: -- Cursor to get the original date earned for a retro element entry
1169: -- ============================================================================
1170: CURSOR c_get_retro_date_earned(c_element_entry_id in number) IS
1171: SELECT substr(fnd_date.date_to_canonical(
1172: trunc(pay_paywsmee_pkg.get_original_date_earned(c_element_entry_id))
1173: ),1,10)
1174: FROM dual;
1175:
1176: TYPE r_rec_retro_ptp IS RECORD

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

3252: AND pelf.element_type_id = c_ele_type_id
3253: AND peev.input_value_id = c_input_val_id
3254: AND peef.assignment_id = c_asg_id
3255: AND peev.screen_entry_value IS NOT NULL
3256: AND pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id)
3257: BETWEEN c_orig_st_date AND c_orig_ed_date;
3258:
3259: CURSOR c_sent_to_abp (c_eff_dt IN DATE) IS
3260: SELECT 1

Line 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,

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

Line 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

3614: ,c_input_val_id IN NUMBER ) IS
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

Line 4294: pay_paywsmee_pkg.get_original_date_earned(

4290:
4291: l_retro_age_cal_dt :=
4292: fnd_date.canonical_to_date(substr(substr(
4293: fnd_date.date_to_canonical(
4294: pay_paywsmee_pkg.get_original_date_earned(
4295: temp_rec.element_entry_id)),1,10),1,8)||'01');
4296:
4297:
4298: IF l_retro_ptp_value <> 0 AND chk_subcat_disp (l_rec_09(i).code

Line 4346: pay_paywsmee_pkg.get_original_date_earned(

4342:
4343: l_retro_age_cal_dt :=
4344: fnd_date.canonical_to_date(substr(substr(
4345: fnd_date.date_to_canonical(
4346: pay_paywsmee_pkg.get_original_date_earned(
4347: temp_rec.element_entry_id)),1,10),1,8)||'01');
4348:
4349: l_ee_age_at_retro := Get_Age(
4350: p_assignment_id

Line 4408: pay_paywsmee_pkg.get_original_date_earned(

4404:
4405: l_retro_age_cal_dt :=
4406: fnd_date.canonical_to_date(substr(substr(
4407: fnd_date.date_to_canonical(
4408: pay_paywsmee_pkg.get_original_date_earned(
4409: temp_rec.element_entry_id)),1,10),1,8)||'01');
4410:
4411: l_ee_age_at_retro := Get_Age(
4412: p_assignment_id

Line 4797: pay_paywsmee_pkg.get_original_date_earned(

4793: l_rec_31_disp := 'Y';
4794: l_rec_31_values(k).processed := 'N';
4795: l_rec_31_values(k).code := l_rec_31(i).code;
4796: l_rec_31_values(k).date_earned := substr(fnd_date.date_to_canonical(
4797: pay_paywsmee_pkg.get_original_date_earned(
4798: temp_rec.element_entry_id)
4799: ),1,10);
4800:
4801: IF l_rec_31_values(k).basis_amount < 0 THEN

Line 4835: pay_paywsmee_pkg.get_original_date_earned(

4831: l_rec_31_values(k).processed := 'N';
4832: l_rec_31_values(k).code := l_rec_31(i).code;
4833: l_rec_31_values(k).date_earned := ' ';
4834: l_rec_31_values(k).date_earned := substr(fnd_date.date_to_canonical(
4835: pay_paywsmee_pkg.get_original_date_earned(
4836: temp_rec.element_entry_id)
4837: ),1,10);
4838:
4839: IF l_rec_31_values(k).basis_amount < 0 THEN

Line 4912: pay_paywsmee_pkg.get_original_date_earned(

4908: l_basis_rec_41_disp := 'Y';
4909: l_rec_41_basis_values(k).processed := 'N';
4910: l_rec_41_basis_values(k).code := l_basis_rec_41(i).code;
4911: l_rec_41_basis_values(k).date_earned := substr(fnd_date.date_to_canonical(
4912: pay_paywsmee_pkg.get_original_date_earned(
4913: temp_rec.element_entry_id)
4914: ),1,10);
4915:
4916: IF l_rec_41_basis_values(k).basis_amount < 0 THEN

Line 4950: pay_paywsmee_pkg.get_original_date_earned(

4946: l_rec_41_basis_values(k).processed := 'N';
4947: l_rec_41_basis_values(k).code := l_basis_rec_41(i).code;
4948: l_rec_41_basis_values(k).date_earned := ' ';
4949: l_rec_41_basis_values(k).date_earned := substr(fnd_date.date_to_canonical(
4950: pay_paywsmee_pkg.get_original_date_earned(
4951: temp_rec.element_entry_id)
4952: ),1,10);
4953:
4954: IF l_rec_41_basis_values(k).basis_amount < 0 THEN