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 743: pqp_pension_types_f pty

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
744: WHERE pei.information_type = 'PQP_NL_ABP_DEDUCTION'
745: AND pei.eei_information_category = 'PQP_NL_ABP_DEDUCTION'
746: AND c_effective_date BETWEEN To_Date(pei.eei_information10,'DD/MM/RRRR') AND
747: To_Date(pei.eei_information11,'DD/MM/RRRR')

Line 800: FROM pqp_pension_types_f pty

796: 'VSG',9,'FPU_E',4,'FPU_R',2,'FPU_S',1,'FPU_T',3,'FPU_B',1) code
797: ,-999999 amount
798: ,ee_contribution_bal_type_id
799: ,er_contribution_bal_type_id
800: FROM pqp_pension_types_f pty
801: WHERE pension_sub_category IN ('OPNP_65','OPNP_W25','OPNP_W50','PPP',
802: 'VSG','FPU_E','FPU_R','FPU_S','FPU_T','FPU_B')
803: AND business_group_id = c_bg_id
804: AND c_effective_date BETWEEN pty.effective_start_date AND

Line 828: pqp_pension_types_f pty

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
829: WHERE pei.information_type = 'PQP_NL_ABP_DEDUCTION'
830: AND pei.eei_information_category = 'PQP_NL_ABP_DEDUCTION'
831: AND c_effective_date BETWEEN To_Date(pei.eei_information10,'DD/MM/RRRR') AND
832: To_Date(pei.eei_information11,'DD/MM/RRRR')

Line 868: FROM pqp_pension_types_f pty

864: ,9 code
865: ,-999999 amount
866: ,ee_contribution_bal_type_id
867: ,er_contribution_bal_type_id
868: FROM pqp_pension_types_f pty
869: WHERE pension_sub_category IN ('FUR_S')
870: AND business_group_id = c_bg_id
871: AND c_effective_date BETWEEN pty.effective_start_date AND
872: pty.effective_end_date

Line 8946: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

8942:
8943: --cursor to check if ASG EIT rows exist
8944: CURSOR c_asg_rows_exist IS
8945: SELECT 1
8946: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
8947: WHERE chg_evt_cd = 'COAPPD'
8948: AND prmtr_01 = 'ASG'
8949: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
8950: AND pty.pension_sub_category = p_sub_cat

Line 8964: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

8960:
8961: --cursor to check if ORG EIT rows exist
8962: CURSOR c_org_rows_exist(c_org_id IN Number) IS
8963: SELECT 1
8964: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
8965: WHERE chg_evt_cd = 'COAPPD'
8966: AND prmtr_01 = 'ORG'
8967: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
8968: AND pty.pension_sub_category = p_sub_cat

Line 8976: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

8972:
8973: --cursor to get the ASG EIT log rows
8974: CURSOR c_get_asg_rows IS
8975: SELECT 1
8976: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
8977: WHERE chg_evt_cd = 'COAPPD'
8978: AND prmtr_01 = 'ASG'
8979: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
8980: AND prmtr_03 = 'Y'

Line 8997: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

8993:
8994: --cursor to get the ORG EIT log rows
8995: CURSOR c_get_org_rows(c_org_id IN Number,c_hire_date IN Date) IS
8996: SELECT 1
8997: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
8998: WHERE chg_evt_cd = 'COAPPD'
8999: AND prmtr_01 = 'ORG'
9000: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
9001: AND prmtr_03 = 'Y'

Line 9067: pqp_pension_types_f pty

9063: FROM pay_run_results prr,
9064: pay_payroll_actions ppa,
9065: pay_assignment_actions paa,
9066: pay_element_type_extra_info pei,
9067: pqp_pension_types_f pty
9068: WHERE paa.assignment_action_id = prr.assignment_action_id
9069: AND paa.payroll_action_id = ppa.payroll_action_id
9070: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date
9071: AND g_extract_params(p_business_group_id).extract_end_date

Line 9300: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE

9296: --============================================================================
9297: FUNCTION Get_Participation_End
9298: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
9299: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
9300: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE
9301: ,p_date_earned IN Date
9302: ,p_end_date OUT NOCOPY Date
9303: ) RETURN Number IS
9304:

Line 9472: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

9468:
9469: --cursor to check if ASG EIT rows exist
9470: CURSOR c_asg_rows_exist IS
9471: SELECT 1
9472: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
9473: WHERE chg_evt_cd = 'COAPPD'
9474: AND prmtr_01 = 'ASG'
9475: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
9476: AND pty.pension_sub_category = 'FUR_S'

Line 9490: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

9486:
9487: --cursor to check if ORG EIT rows exist
9488: CURSOR c_org_rows_exist(c_org_id IN Number) IS
9489: SELECT 1
9490: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
9491: WHERE chg_evt_cd = 'COAPPD'
9492: AND prmtr_01 = 'ORG'
9493: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
9494: AND pty.pension_sub_category = 'FUR_S'

Line 9502: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

9498:
9499: --cursor to get the old and new start and end dates from the ASG EIT
9500: CURSOR c_get_asg_rows IS
9501: SELECT old_val1,new_val1,old_val2,new_val2
9502: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
9503: WHERE chg_evt_cd = 'COAPPD'
9504: AND prmtr_01 = 'ASG'
9505: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
9506: AND prmtr_03 = 'Y'

Line 9523: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

9519:
9520: --cursor to get the old and new start and end dates from the ORG EIT
9521: CURSOR c_get_org_rows(c_org_id IN Number,c_hire_date IN Date) IS
9522: SELECT old_val1,new_val1,old_val2,new_val2
9523: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
9524: WHERE chg_evt_cd = 'COAPPD'
9525: AND prmtr_01 = 'ORG'
9526: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
9527: AND prmtr_03 = 'Y'

Line 9593: pqp_pension_types_f pty

9589: FROM pay_run_results prr,
9590: pay_payroll_actions ppa,
9591: pay_assignment_actions paa,
9592: pay_element_type_extra_info pei,
9593: pqp_pension_types_f pty
9594: WHERE paa.assignment_action_id = prr.assignment_action_id
9595: AND paa.payroll_action_id = ppa.payroll_action_id
9596: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date
9597: AND g_extract_params(p_business_group_id).extract_end_date

Line 9918: pqp_pension_types_f pty

9914:
9915: CURSOR c_ppp_asg1 IS
9916: SELECT 1
9917: FROM per_assignment_extra_info paei,
9918: pqp_pension_types_f pty
9919: WHERE paei.information_type = 'NL_ABP_PI'
9920: AND paei.aei_information_category = 'NL_ABP_PI'
9921: AND paei.assignment_id = p_assignment_id
9922: AND fnd_number.canonical_to_number(NVL(aei_information3,-1)) = pty.pension_type_id

Line 9936: pqp_pension_types_f pty

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

Line 9952: pqp_pension_types_f pty,

9948: CURSOR c_rr_cur IS
9949: SELECT 1
9950: FROM per_all_assignments_f paf,
9951: hr_organization_information hoi,
9952: pqp_pension_types_f pty,
9953: pay_all_payrolls_f ppf
9954: WHERE paf.assignment_id = p_assignment_id
9955: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
9956: AND paf.payroll_id = ppf.payroll_id

Line 10079: pqp_pension_types_f pty

10075: FROM pay_run_results prr,
10076: pay_payroll_actions ppa,
10077: pay_assignment_actions paa,
10078: pay_element_type_extra_info pei,
10079: pqp_pension_types_f pty
10080: WHERE paa.assignment_action_id = prr.assignment_action_id
10081: AND paa.payroll_action_id = ppa.payroll_action_id
10082: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date
10083: AND g_extract_params(p_business_group_id).extract_end_date

Line 10104: pqp_pension_types_f pty,

10100: ,'FPU_S','S'
10101: ,'FPU_T' ,'B') fpu_code
10102: FROM per_all_assignments_f paf,
10103: hr_organization_information hoi,
10104: pqp_pension_types_f pty,
10105: pay_all_payrolls_f ppf
10106: WHERE paf.assignment_id = p_assignment_id
10107: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
10108: AND paf.payroll_id = ppf.payroll_id

Line 10156: pqp_pension_types_f pty

10152: ,'FPU_R','A'
10153: ,'FPU_S','S'
10154: ,'FPU_T' ,'B') fpu_code
10155: FROM per_assignment_extra_info paei,
10156: pqp_pension_types_f pty
10157: WHERE paei.information_type = 'NL_ABP_PI'
10158: AND paei.aei_information_category = 'NL_ABP_PI'
10159: AND paei.assignment_id = p_assignment_id
10160: AND fnd_number.canonical_to_number(NVL(aei_information3,-1)) = pty.pension_type_id

Line 10682: pqp_pension_types_f pty

10678: FROM pay_run_results prr,
10679: pay_payroll_actions ppa,
10680: pay_assignment_actions paa,
10681: pay_element_type_extra_info pei,
10682: pqp_pension_types_f pty
10683: WHERE paa.assignment_action_id = prr.assignment_action_id
10684: AND paa.payroll_action_id = ppa.payroll_action_id
10685: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date
10686: AND g_extract_params(p_business_group_id).extract_end_date

Line 11832: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

11828:
11829: --cursor to check if ASG EIT rows exist
11830: CURSOR c_asg_rows_exist IS
11831: SELECT 1
11832: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
11833: WHERE chg_evt_cd = 'COAPPD'
11834: AND prmtr_01 = 'ASG'
11835: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
11836: AND pty.pension_sub_category = 'IPAP'

Line 11850: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

11846:
11847: --cursor to check if ORG EIT rows exist
11848: CURSOR c_org_rows_exist(c_org_id IN Number) IS
11849: SELECT 1
11850: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
11851: WHERE chg_evt_cd = 'COAPPD'
11852: AND prmtr_01 = 'ORG'
11853: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
11854: AND pty.pension_sub_category = 'IPAP'

Line 11862: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

11858:
11859: --cursor to get the old and new start and end dates from the ASG EIT
11860: CURSOR c_get_asg_rows IS
11861: SELECT old_val1,new_val1,old_val2,new_val2
11862: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
11863: WHERE chg_evt_cd = 'COAPPD'
11864: AND prmtr_01 = 'ASG'
11865: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
11866: AND prmtr_03 = 'Y'

Line 11883: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty

11879:
11880: --cursor to get the old and new start and end dates from the ORG EIT
11881: CURSOR c_get_org_rows(c_org_id IN Number,c_hire_date IN Date) IS
11882: SELECT old_val1,new_val1,old_val2,new_val2
11883: FROM ben_ext_chg_evt_log bec,pqp_pension_types_f pty
11884: WHERE chg_evt_cd = 'COAPPD'
11885: AND prmtr_01 = 'ORG'
11886: AND Fnd_Number.canonical_to_number(prmtr_02) = pty.pension_type_id
11887: AND prmtr_03 = 'Y'

Line 11953: pqp_pension_types_f pty

11949: FROM pay_run_results prr,
11950: pay_payroll_actions ppa,
11951: pay_assignment_actions paa,
11952: pay_element_type_extra_info pei,
11953: pqp_pension_types_f pty
11954: WHERE paa.assignment_action_id = prr.assignment_action_id
11955: AND paa.payroll_action_id = ppa.payroll_action_id
11956: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date
11957: AND g_extract_params(p_business_group_id).extract_end_date

Line 13366: FROM pay_element_type_extra_info,pqp_pension_types_f pty

13362: (SELECT assignment_action_id
13363: FROM pay_run_results
13364: WHERE element_type_id IN
13365: (SELECT element_type_id
13366: FROM pay_element_type_extra_info,pqp_pension_types_f pty
13367: WHERE information_type = 'PQP_NL_ABP_DEDUCTION'
13368: AND eei_information_category = 'PQP_NL_ABP_DEDUCTION'
13369: AND eei_information2 = Fnd_Number.number_to_canonical(pty.pension_type_id)
13370: AND pty.pension_sub_category = 'FUR_S'

Line 13451: pqp_pension_types_f pty

13447: FROM pay_run_results prr,
13448: pay_payroll_actions ppa,
13449: pay_assignment_actions paa,
13450: pay_element_type_extra_info pei,
13451: pqp_pension_types_f pty
13452: WHERE paa.assignment_action_id = prr.assignment_action_id
13453: AND paa.payroll_action_id = ppa.payroll_action_id
13454: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date
13455: AND g_extract_params(p_business_group_id).extract_end_date

Line 13749: FROM pay_element_type_extra_info,pqp_pension_types_f pty

13745: (SELECT assignment_action_id
13746: FROM pay_run_results
13747: WHERE element_type_id IN
13748: (SELECT element_type_id
13749: FROM pay_element_type_extra_info,pqp_pension_types_f pty
13750: WHERE information_type = 'PQP_NL_ABP_DEDUCTION'
13751: AND eei_information_category = 'PQP_NL_ABP_DEDUCTION'
13752: AND eei_information2 = Fnd_Number.number_to_canonical(pty.pension_type_id)
13753: AND pty.pension_sub_category = 'IPAP'