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 PQP_PENSION_TYPES_F

Line 762: pqp_pension_types_f pty

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
763: WHERE pei.information_type = 'PQP_NL_ABP_DEDUCTION'
764: AND pei.eei_information_category = 'PQP_NL_ABP_DEDUCTION'
765: AND c_effective_date BETWEEN To_Date(pei.eei_information10,'DD/MM/RRRR') AND
766: To_Date(pei.eei_information11,'DD/MM/RRRR')

Line 819: FROM pqp_pension_types_f pty

815: 'VSG',9,'FPU_E',4,'FPU_R',2,'FPU_S',1,'FPU_T',3,'FPU_B',1) code
816: ,-999999 amount
817: ,ee_contribution_bal_type_id
818: ,er_contribution_bal_type_id
819: FROM pqp_pension_types_f pty
820: WHERE pension_sub_category IN ('OPNP_65','OPNP_W25','OPNP_W50','PPP',
821: 'VSG','FPU_E','FPU_R','FPU_S','FPU_T','FPU_B')
822: AND business_group_id = c_bg_id
823: AND c_effective_date BETWEEN pty.effective_start_date AND

Line 847: pqp_pension_types_f pty

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
848: WHERE pei.information_type = 'PQP_NL_ABP_DEDUCTION'
849: AND pei.eei_information_category = 'PQP_NL_ABP_DEDUCTION'
850: AND c_effective_date BETWEEN To_Date(pei.eei_information10,'DD/MM/RRRR') AND
851: To_Date(pei.eei_information11,'DD/MM/RRRR')

Line 887: FROM pqp_pension_types_f pty

883: ,9 code
884: ,-999999 amount
885: ,ee_contribution_bal_type_id
886: ,er_contribution_bal_type_id
887: FROM pqp_pension_types_f pty
888: WHERE pension_sub_category IN ('FUR_S')
889: AND business_group_id = c_bg_id
890: AND c_effective_date BETWEEN pty.effective_start_date AND
891: pty.effective_end_date

Line 9285: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

9281:
9282: --cursor to check if ASG EIT rows exist
9283: CURSOR c_asg_rows_exist IS
9284: SELECT 1
9285: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
9286: WHERE chg_evt_cd = 'COAPPD'
9287: AND prmtr_01 = 'ASG'
9288: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
9289: AND pty.pension_sub_category = p_sub_cat

Line 9303: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

9299:
9300: --cursor to check if ORG EIT rows exist
9301: CURSOR c_org_rows_exist(c_org_id IN Number) IS
9302: SELECT 1
9303: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
9304: WHERE chg_evt_cd = 'COAPPD'
9305: AND prmtr_01 = 'ORG'
9306: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
9307: AND pty.pension_sub_category = p_sub_cat

Line 9315: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

9311:
9312: --cursor to get the ASG EIT log rows
9313: CURSOR c_get_asg_rows IS
9314: SELECT 1
9315: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
9316: WHERE chg_evt_cd = 'COAPPD'
9317: AND prmtr_01 = 'ASG'
9318: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
9319: AND prmtr_03 = 'Y'

Line 9336: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

9332:
9333: --cursor to get the ORG EIT log rows
9334: CURSOR c_get_org_rows(c_org_id IN Number,c_hire_date IN Date) IS
9335: SELECT 1
9336: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
9337: WHERE chg_evt_cd = 'COAPPD'
9338: AND prmtr_01 = 'ORG'
9339: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
9340: AND prmtr_03 = 'Y'

Line 9406: pqp_pension_types_f pty

9402: FROM pay_run_results prr,
9403: pay_payroll_actions ppa,
9404: pay_assignment_actions paa,
9405: pay_element_type_extra_info pei,
9406: pqp_pension_types_f pty
9407: WHERE paa.assignment_action_id = prr.assignment_action_id
9408: AND paa.payroll_action_id = ppa.payroll_action_id
9409: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date
9410: AND g_extract_params(p_business_group_id).extract_end_date

Line 9639: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE

9635: --============================================================================
9636: FUNCTION Get_Participation_End
9637: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
9638: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
9639: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE
9640: ,p_date_earned IN Date
9641: ,p_end_date OUT NOCOPY Date
9642: ) RETURN Number IS
9643:

Line 9811: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

9807:
9808: --cursor to check if ASG EIT rows exist
9809: CURSOR c_asg_rows_exist IS
9810: SELECT 1
9811: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
9812: WHERE chg_evt_cd = 'COAPPD'
9813: AND prmtr_01 = 'ASG'
9814: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
9815: AND pty.pension_sub_category = 'FUR_S'

Line 9829: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

9825:
9826: --cursor to check if ORG EIT rows exist
9827: CURSOR c_org_rows_exist(c_org_id IN Number) IS
9828: SELECT 1
9829: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
9830: WHERE chg_evt_cd = 'COAPPD'
9831: AND prmtr_01 = 'ORG'
9832: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
9833: AND pty.pension_sub_category = 'FUR_S'

Line 9841: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

9837:
9838: --cursor to get the old and new start and end dates from the ASG EIT
9839: CURSOR c_get_asg_rows IS
9840: SELECT old_val1,new_val1,old_val2,new_val2
9841: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
9842: WHERE chg_evt_cd = 'COAPPD'
9843: AND prmtr_01 = 'ASG'
9844: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
9845: AND prmtr_03 = 'Y'

Line 9862: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

9858:
9859: --cursor to get the old and new start and end dates from the ORG EIT
9860: CURSOR c_get_org_rows(c_org_id IN Number,c_hire_date IN Date) IS
9861: SELECT old_val1,new_val1,old_val2,new_val2
9862: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
9863: WHERE chg_evt_cd = 'COAPPD'
9864: AND prmtr_01 = 'ORG'
9865: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
9866: AND prmtr_03 = 'Y'

Line 9932: pqp_pension_types_f pty

9928: FROM pay_run_results prr,
9929: pay_payroll_actions ppa,
9930: pay_assignment_actions paa,
9931: pay_element_type_extra_info pei,
9932: pqp_pension_types_f pty
9933: WHERE paa.assignment_action_id = prr.assignment_action_id
9934: AND paa.payroll_action_id = ppa.payroll_action_id
9935: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date
9936: AND g_extract_params(p_business_group_id).extract_end_date

Line 10257: pqp_pension_types_f pty

10253:
10254: CURSOR c_ppp_asg1 IS
10255: SELECT 1
10256: FROM per_assignment_extra_info paei,
10257: pqp_pension_types_f pty
10258: WHERE paei.information_type = 'NL_ABP_PI'
10259: AND paei.aei_information_category = 'NL_ABP_PI'
10260: AND paei.assignment_id = p_assignment_id
10261: AND fnd_number.canonical_to_number(NVL(aei_information3,-1)) = pty.pension_type_id

Line 10275: pqp_pension_types_f pty

10271: FROM pay_run_results prr,
10272: pay_payroll_actions ppa,
10273: pay_assignment_actions paa,
10274: pay_element_type_extra_info pei,
10275: pqp_pension_types_f pty
10276: WHERE paa.assignment_action_id = prr.assignment_action_id
10277: AND paa.payroll_action_id = ppa.payroll_action_id
10278: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date
10279: AND g_extract_params(p_business_group_id).extract_end_date

Line 10291: pqp_pension_types_f pty,

10287: CURSOR c_rr_cur IS
10288: SELECT 1
10289: FROM per_all_assignments_f paf,
10290: hr_organization_information hoi,
10291: pqp_pension_types_f pty,
10292: pay_all_payrolls_f ppf
10293: WHERE paf.assignment_id = p_assignment_id
10294: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
10295: AND paf.payroll_id = ppf.payroll_id

Line 10418: pqp_pension_types_f pty

10414: FROM pay_run_results prr,
10415: pay_payroll_actions ppa,
10416: pay_assignment_actions paa,
10417: pay_element_type_extra_info pei,
10418: pqp_pension_types_f pty
10419: WHERE paa.assignment_action_id = prr.assignment_action_id
10420: AND paa.payroll_action_id = ppa.payroll_action_id
10421: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date
10422: AND g_extract_params(p_business_group_id).extract_end_date

Line 10443: pqp_pension_types_f pty,

10439: ,'FPU_S','S'
10440: ,'FPU_T' ,'B') fpu_code
10441: FROM per_all_assignments_f paf,
10442: hr_organization_information hoi,
10443: pqp_pension_types_f pty,
10444: pay_all_payrolls_f ppf
10445: WHERE paf.assignment_id = p_assignment_id
10446: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
10447: AND paf.payroll_id = ppf.payroll_id

Line 10495: pqp_pension_types_f pty

10491: ,'FPU_R','A'
10492: ,'FPU_S','S'
10493: ,'FPU_T' ,'B') fpu_code
10494: FROM per_assignment_extra_info paei,
10495: pqp_pension_types_f pty
10496: WHERE paei.information_type = 'NL_ABP_PI'
10497: AND paei.aei_information_category = 'NL_ABP_PI'
10498: AND paei.assignment_id = p_assignment_id
10499: AND fnd_number.canonical_to_number(NVL(aei_information3,-1)) = pty.pension_type_id

Line 11021: pqp_pension_types_f pty

11017: FROM pay_run_results prr,
11018: pay_payroll_actions ppa,
11019: pay_assignment_actions paa,
11020: pay_element_type_extra_info pei,
11021: pqp_pension_types_f pty
11022: WHERE paa.assignment_action_id = prr.assignment_action_id
11023: AND paa.payroll_action_id = ppa.payroll_action_id
11024: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date
11025: AND g_extract_params(p_business_group_id).extract_end_date

Line 12201: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

12197:
12198: --cursor to check if ASG EIT rows exist
12199: CURSOR c_asg_rows_exist IS
12200: SELECT 1
12201: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
12202: WHERE chg_evt_cd = 'COAPPD'
12203: AND prmtr_01 = 'ASG'
12204: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
12205: AND pty.pension_sub_category = 'IPAP'

Line 12219: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

12215:
12216: --cursor to check if ORG EIT rows exist
12217: CURSOR c_org_rows_exist(c_org_id IN Number) IS
12218: SELECT 1
12219: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
12220: WHERE chg_evt_cd = 'COAPPD'
12221: AND prmtr_01 = 'ORG'
12222: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
12223: AND pty.pension_sub_category = 'IPAP'

Line 12231: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

12227:
12228: --cursor to get the old and new start and end dates from the ASG EIT
12229: CURSOR c_get_asg_rows IS
12230: SELECT old_val1,new_val1,old_val2,new_val2
12231: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
12232: WHERE chg_evt_cd = 'COAPPD'
12233: AND prmtr_01 = 'ASG'
12234: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
12235: AND prmtr_03 = 'Y'

Line 12252: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

12248:
12249: --cursor to get the old and new start and end dates from the ORG EIT
12250: CURSOR c_get_org_rows(c_org_id IN Number,c_hire_date IN Date) IS
12251: SELECT old_val1,new_val1,old_val2,new_val2
12252: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
12253: WHERE chg_evt_cd = 'COAPPD'
12254: AND prmtr_01 = 'ORG'
12255: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
12256: AND prmtr_03 = 'Y'

Line 12322: pqp_pension_types_f pty

12318: FROM pay_run_results prr,
12319: pay_payroll_actions ppa,
12320: pay_assignment_actions paa,
12321: pay_element_type_extra_info pei,
12322: pqp_pension_types_f pty
12323: WHERE paa.assignment_action_id = prr.assignment_action_id
12324: AND paa.payroll_action_id = ppa.payroll_action_id
12325: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date
12326: AND g_extract_params(p_business_group_id).extract_end_date

Line 13735: FROM pay_element_type_extra_info,pqp_pension_types_f pty

13731: (SELECT assignment_action_id
13732: FROM pay_run_results
13733: WHERE element_type_id IN
13734: (SELECT element_type_id
13735: FROM pay_element_type_extra_info,pqp_pension_types_f pty
13736: WHERE information_type = 'PQP_NL_ABP_DEDUCTION'
13737: AND eei_information_category = 'PQP_NL_ABP_DEDUCTION'
13738: AND eei_information2 = Fnd_Number.number_to_canonical(pty.pension_type_id)
13739: AND pty.pension_sub_category = 'FUR_S'

Line 13820: pqp_pension_types_f pty

13816: FROM pay_run_results prr,
13817: pay_payroll_actions ppa,
13818: pay_assignment_actions paa,
13819: pay_element_type_extra_info pei,
13820: pqp_pension_types_f pty
13821: WHERE paa.assignment_action_id = prr.assignment_action_id
13822: AND paa.payroll_action_id = ppa.payroll_action_id
13823: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date
13824: AND g_extract_params(p_business_group_id).extract_end_date

Line 14118: FROM pay_element_type_extra_info,pqp_pension_types_f pty

14114: (SELECT assignment_action_id
14115: FROM pay_run_results
14116: WHERE element_type_id IN
14117: (SELECT element_type_id
14118: FROM pay_element_type_extra_info,pqp_pension_types_f pty
14119: WHERE information_type = 'PQP_NL_ABP_DEDUCTION'
14120: AND eei_information_category = 'PQP_NL_ABP_DEDUCTION'
14121: AND eei_information2 = Fnd_Number.number_to_canonical(pty.pension_type_id)
14122: AND pty.pension_sub_category = 'IPAP'