APPS.PAY_GB_STUDENT_LOANS_PKG dependencies on PAY_BALANCE_TYPES

Line 54: from pay_balance_types

50: ) is
51:
52: cursor c_balance_id(p_name in VARCHAR2) is
53: select balance_type_id
54: from pay_balance_types
55: where balance_name = p_name
56: and legislation_code = 'GB';
57:
58: cursor c_itd_asgact(p_asg in NUMBER,

Line 119: l_balance_type_id PAY_BALANCE_TYPES.balance_type_id%TYPE;

115: l_itd_action_id PAY_ASSIGNMENT_ACTIONS.assignment_action_id%TYPE;
116: l_itd_source_id PAY_RUN_RESULTS.source_id%TYPE;
117: l_ptd_action_id PAY_ASSIGNMENT_ACTIONS.assignment_action_id%TYPE;
118: l_ptd_source_id PAY_RUN_RESULTS.source_id%TYPE;
119: l_balance_type_id PAY_BALANCE_TYPES.balance_type_id%TYPE;
120: l_balance_type_id2 PAY_BALANCE_TYPES.balance_type_id%TYPE;
121: l_effective_date DATE;
122: l_name PAY_BALANCE_TYPES.BALANCE_NAME%TYPE;
123: l_name2 PAY_BALANCE_TYPES.BALANCE_NAME%TYPE;

Line 120: l_balance_type_id2 PAY_BALANCE_TYPES.balance_type_id%TYPE;

116: l_itd_source_id PAY_RUN_RESULTS.source_id%TYPE;
117: l_ptd_action_id PAY_ASSIGNMENT_ACTIONS.assignment_action_id%TYPE;
118: l_ptd_source_id PAY_RUN_RESULTS.source_id%TYPE;
119: l_balance_type_id PAY_BALANCE_TYPES.balance_type_id%TYPE;
120: l_balance_type_id2 PAY_BALANCE_TYPES.balance_type_id%TYPE;
121: l_effective_date DATE;
122: l_name PAY_BALANCE_TYPES.BALANCE_NAME%TYPE;
123: l_name2 PAY_BALANCE_TYPES.BALANCE_NAME%TYPE;
124:

Line 122: l_name PAY_BALANCE_TYPES.BALANCE_NAME%TYPE;

118: l_ptd_source_id PAY_RUN_RESULTS.source_id%TYPE;
119: l_balance_type_id PAY_BALANCE_TYPES.balance_type_id%TYPE;
120: l_balance_type_id2 PAY_BALANCE_TYPES.balance_type_id%TYPE;
121: l_effective_date DATE;
122: l_name PAY_BALANCE_TYPES.BALANCE_NAME%TYPE;
123: l_name2 PAY_BALANCE_TYPES.BALANCE_NAME%TYPE;
124:
125: BEGIN
126:

Line 123: l_name2 PAY_BALANCE_TYPES.BALANCE_NAME%TYPE;

119: l_balance_type_id PAY_BALANCE_TYPES.balance_type_id%TYPE;
120: l_balance_type_id2 PAY_BALANCE_TYPES.balance_type_id%TYPE;
121: l_effective_date DATE;
122: l_name PAY_BALANCE_TYPES.BALANCE_NAME%TYPE;
123: l_name2 PAY_BALANCE_TYPES.BALANCE_NAME%TYPE;
124:
125: BEGIN
126:
127: hr_utility.set_location('Entering..'||l_proc,10);