APPS.PAY_GB_RTI_FPS_ADHOC dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 20: p_ovn per_assignment_extra_info.object_version_number%TYPE;

16: (Non-Mandatory)
17: */
18: ----
19: process_asg_id number;
20: p_ovn per_assignment_extra_info.object_version_number%TYPE;
21: p_aei_id per_assignment_extra_info.assignment_extra_info_id%TYPE;
22: v_assignment_id number;
23: l_formula_id number;
24: l_include_flag varchar2(1) DEFAULT 'N';

Line 21: p_aei_id per_assignment_extra_info.assignment_extra_info_id%TYPE;

17: */
18: ----
19: process_asg_id number;
20: p_ovn per_assignment_extra_info.object_version_number%TYPE;
21: p_aei_id per_assignment_extra_info.assignment_extra_info_id%TYPE;
22: v_assignment_id number;
23: l_formula_id number;
24: l_include_flag varchar2(1) DEFAULT 'N';
25: l_tab_asg_set_amnds pqp_budget_maintenance.t_asg_set_amnds;

Line 48: FROM per_assignment_extra_info

44: (p_assignment_id IN number) IS
45: SELECT assignment_id
46: ,object_version_number
47: ,assignment_extra_info_id
48: FROM per_assignment_extra_info
49: WHERE assignment_id = p_assignment_id
50: AND information_type = 'GB_PAY_RTI'
51: AND aei_information_category = 'GB_PAY_RTI';
52: BEGIN