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 121: l_balance_type_id PAY_BALANCE_TYPES.balance_type_id%TYPE;

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

Line 122: l_balance_type_id2 PAY_BALANCE_TYPES.balance_type_id%TYPE;

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

Line 124: l_name PAY_BALANCE_TYPES.BALANCE_NAME%TYPE;

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

Line 125: l_name2 PAY_BALANCE_TYPES.BALANCE_NAME%TYPE;

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

Line 1682: FROM PAY_BALANCE_TYPES PBT,

1678: hr_utility.trace('l_override_freq Period Type:'||l_override_freq);
1679:
1680: SELECT PDB.DEFINED_BALANCE_ID
1681: INTO l_def_balance_id
1682: FROM PAY_BALANCE_TYPES PBT,
1683: PAY_DEFINED_BALANCES PDB,
1684: PAY_BALANCE_DIMENSIONS PBD
1685: WHERE PDB.BALANCE_TYPE_ID=PBT.BALANCE_TYPE_ID
1686: AND PBT.BALANCE_NAME = 'Court Order'