APPS.PAY_GB_RTI_UPD dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 92: FROM per_assignment_extra_info

88: SELECT assignment_extra_info_id
89: ,object_version_number
90: INTO p_assignment_extra_info_id
91: ,p_object_version_number
92: FROM per_assignment_extra_info
93: WHERE assignment_id = p_assignment_id
94: AND aei_information_category = 'GB_RTI_AGGREGATION';
95: EXCEPTION
96: WHEN no_data_found THEN

Line 580: FROM per_assignment_extra_info paei

576: ,paei.assignment_id assignment_id
577: ,paei.aei_information3 assignment_number
578: ,paei.aei_information4 payroll_id
579: ,paei.object_version_number object_version_number
580: FROM per_assignment_extra_info paei
581: WHERE paei.assignment_id = v_assignment_id
582: AND information_type = 'GB_RTI_AGGREGATION';
583:
584:

Line 588: v_assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%TYPE;

584:
585: v_person_details c_person_details%ROWTYPE;
586: l_payroll_id varchar2(150);
587: l_primary_asg_id number;
588: v_assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%TYPE;
589: v_payroll_details c_payroll_details%ROWTYPE;
590: l_person_id number;
591: check_payroll_exp EXCEPTION;
592: l_assignment_number varchar2(100);

Line 724: SELECT per_assignment_extra_info_s.nextval

720: INTO v_payroll_details;
721:
722: IF c_payroll_details%NOTFOUND THEN
723: hr_utility.trace('For this assignment extra_information doesnt exists hence inserting it');
724: SELECT per_assignment_extra_info_s.nextval
725: INTO v_assignment_extra_info_id
726: FROM dual;
727:
728: hr_utility.trace ('assignment_id:'