APPS.PAY_GB_RTI_FPS_ADHOC dependencies on PQP_BUDGET_MAINTENANCE

Line 25: l_tab_asg_set_amnds pqp_budget_maintenance.t_asg_set_amnds;

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;
26: invalid_assg_set_id EXCEPTION;
27: CURSOR c_assignments
28: (p_effective_date_c IN date
29: ,p_assignment_set_id_c IN number) IS

Line 54: pqp_budget_maintenance.get_asg_set_details

50: AND information_type = 'GB_PAY_RTI'
51: AND aei_information_category = 'GB_PAY_RTI';
52: BEGIN
53: IF p_assignment_set_id IS NOT NULL THEN
54: pqp_budget_maintenance.get_asg_set_details
55: (p_assignment_set_id => p_assignment_set_id
56: ,p_formula_id => l_formula_id
57: ,p_tab_asg_set_amnds => l_tab_asg_set_amnds);
58: END IF;

Line 69: l_include_flag := pqp_budget_maintenance.chk_is_asg_in_asg_set

65: FOR i IN c_assignments (p_effective_date
66: ,p_assignment_set_id) LOOP
67: l_include_flag := 'N';
68:
69: l_include_flag := pqp_budget_maintenance.chk_is_asg_in_asg_set
70: (p_assignment_id => i.assignment_id
71: ,p_formula_id => l_formula_id
72: ,p_tab_asg_set_amnds => l_tab_asg_set_amnds
73: ,p_effective_date => p_effective_date);