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_EXT_FUNCTIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 321: FROM per_all_assignments_f

317: ) IS
318:
319: CURSOR c_get_person_id IS
320: SELECT person_id,business_group_id
321: FROM per_all_assignments_f
322: WHERE assignment_id = p_assignment_id
323: AND p_effective_date BETWEEN effective_start_date
324: AND effective_end_date;
325:

Line 326: l_person_id per_all_assignments_f.person_id%TYPE;

322: WHERE assignment_id = p_assignment_id
323: AND p_effective_date BETWEEN effective_start_date
324: AND effective_end_date;
325:
326: l_person_id per_all_assignments_f.person_id%TYPE;
327: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
328: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
329: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
330: l_sub_cat pqp_pension_types_f.pension_sub_category%TYPE;

Line 327: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

323: AND p_effective_date BETWEEN effective_start_date
324: AND effective_end_date;
325:
326: l_person_id per_all_assignments_f.person_id%TYPE;
327: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
328: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
329: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
330: l_sub_cat pqp_pension_types_f.pension_sub_category%TYPE;
331: l_enabled VARCHAR2(1) := 'N';

Line 400: FROM per_all_assignments_f

396: ) IS
397:
398: CURSOR c_get_person_id IS
399: SELECT person_id,business_group_id
400: FROM per_all_assignments_f
401: WHERE assignment_id = p_assignment_id
402: AND p_effective_date BETWEEN effective_start_date
403: AND effective_end_date;
404:

Line 414: l_person_id per_all_assignments_f.person_id%TYPE;

410: WHERE person_id = c_person_id
411: AND chg_evt_cd = 'COAPP'
412: AND prmtr_03 = fnd_number.number_to_canonical(p_assignment_extra_info_id);
413:
414: l_person_id per_all_assignments_f.person_id%TYPE;
415: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
416: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
417: l_sub_cat pqp_pension_types_f.pension_sub_category%TYPE;
418: l_enabled VARCHAR2(1) := 'N';

Line 415: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

411: AND chg_evt_cd = 'COAPP'
412: AND prmtr_03 = fnd_number.number_to_canonical(p_assignment_extra_info_id);
413:
414: l_person_id per_all_assignments_f.person_id%TYPE;
415: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
416: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
417: l_sub_cat pqp_pension_types_f.pension_sub_category%TYPE;
418: l_enabled VARCHAR2(1) := 'N';
419: l_log_xst_ovn NUMBER;

Line 617: FROM per_all_assignments_f

613: ) IS
614:
615: CURSOR c_get_person_id IS
616: SELECT person_id,business_group_id
617: FROM per_all_assignments_f
618: WHERE assignment_id = p_assignment_id
619: AND p_effective_date BETWEEN effective_start_date
620: AND effective_end_date;
621:

Line 622: l_person_id per_all_assignments_f.person_id%TYPE;

618: WHERE assignment_id = p_assignment_id
619: AND p_effective_date BETWEEN effective_start_date
620: AND effective_end_date;
621:
622: l_person_id per_all_assignments_f.person_id%TYPE;
623: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
624: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
625: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
626: l_enabled varchar2(1) := 'N';

Line 623: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

619: AND p_effective_date BETWEEN effective_start_date
620: AND effective_end_date;
621:
622: l_person_id per_all_assignments_f.person_id%TYPE;
623: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
624: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
625: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
626: l_enabled varchar2(1) := 'N';
627:

Line 678: FROM per_all_assignments_f

674: ) IS
675:
676: CURSOR c_get_person_id IS
677: SELECT person_id,business_group_id
678: FROM per_all_assignments_f
679: WHERE assignment_id = p_assignment_id
680: AND p_effective_date BETWEEN effective_start_date
681: AND effective_end_date;
682:

Line 694: l_person_id per_all_assignments_f.person_id%TYPE;

690: AND prmtr_02 = p_aei_information3_o
691: AND person_id = c_person_id
692: AND chg_evt_cd = 'COSIPD';
693:
694: l_person_id per_all_assignments_f.person_id%TYPE;
695: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
696: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
697: l_cd ben_ext_chg_evt_log.chg_evt_cd%TYPE;
698: l_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;

Line 695: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

691: AND person_id = c_person_id
692: AND chg_evt_cd = 'COSIPD';
693:
694: l_person_id per_all_assignments_f.person_id%TYPE;
695: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
696: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
697: l_cd ben_ext_chg_evt_log.chg_evt_cd%TYPE;
698: l_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;
699: l_prmtr1 ben_ext_chg_evt_log.prmtr_01%TYPE;

Line 774: FROM per_all_assignments_f

770: ) IS
771:
772: CURSOR c_get_person_id IS
773: SELECT person_id,business_group_id,payroll_id
774: FROM per_all_assignments_f
775: WHERE assignment_id = p_assignment_id
776: AND p_effective_date BETWEEN effective_start_date
777: AND effective_end_date;
778:

Line 790: FROM per_all_assignments_f

786:
787: --cursor to fetch the minimum start date of the assignment
788: CURSOR c_get_min_asg_start IS
789: SELECT min(effective_start_date)
790: FROM per_all_assignments_f
791: WHERE assignment_id = p_assignment_id;
792:
793: --cursor to fetch the start date of the first unprocessed
794: --payroll period, given the max date earned

Line 813: l_person_id per_all_assignments_f.person_id%TYPE;

809: WHERE payroll_id = c_payroll_id
810: AND c_start_date BETWEEN start_date
811: AND end_date;
812:
813: l_person_id per_all_assignments_f.person_id%TYPE;
814: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
815: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
816: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
817: l_date Date;

Line 814: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

810: AND c_start_date BETWEEN start_date
811: AND end_date;
812:
813: l_person_id per_all_assignments_f.person_id%TYPE;
814: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
815: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
816: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
817: l_date Date;
818: l_payroll_id Number;

Line 941: FROM per_all_assignments_f

937: ) IS
938:
939: CURSOR c_get_person_id IS
940: SELECT person_id,business_group_id,payroll_id
941: FROM per_all_assignments_f
942: WHERE assignment_id = p_assignment_id
943: AND p_effective_date BETWEEN effective_start_date
944: AND effective_end_date;
945:

Line 957: FROM per_all_assignments_f

953:
954: --cursor to fetch the minimum start date of the assignment
955: CURSOR c_get_min_asg_start IS
956: SELECT min(effective_start_date)
957: FROM per_all_assignments_f
958: WHERE assignment_id = p_assignment_id;
959:
960: --cursor to fetch the start date of the first unprocessed
961: --payroll period, given the max date earned

Line 989: l_person_id per_all_assignments_f.person_id%TYPE;

985: WHERE person_id = c_person_id
986: AND chg_evt_cd = 'COAPKOP'
987: AND prmtr_03 = fnd_number.number_to_canonical(p_assignment_extra_info_id);
988:
989: l_person_id per_all_assignments_f.person_id%TYPE;
990: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
991: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
992: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
993: l_date Date;

Line 990: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

986: AND chg_evt_cd = 'COAPKOP'
987: AND prmtr_03 = fnd_number.number_to_canonical(p_assignment_extra_info_id);
988:
989: l_person_id per_all_assignments_f.person_id%TYPE;
990: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
991: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
992: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
993: l_date Date;
994: l_payroll_id Number;