APPS.PAY_SG_SOE dependencies on PAY_BALANCE_TYPES

Line 105: p_balance_name in pay_balance_types.balance_name%type,

101:
102: procedure current_and_ytd_balances
103: (p_prepaid_tag in varchar,
104: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
105: p_balance_name in pay_balance_types.balance_name%type,
106: p_person_id in per_all_people_f.person_id%type,
107: p_current_balance out nocopy number,
108: p_ytd_balance out nocopy number)
109: is

Line 144: c_balance_name pay_balance_types.balance_name%type,

140:
141: /* Bug:2883606. Cursor to get the balance values from pay_balance_pkg.get_value */
142: cursor balance_value
143: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
144: c_balance_name pay_balance_types.balance_name%type,
145: c_dimension_name pay_balance_dimensions.dimension_name%type) is
146: select nvl(pay_balance_pkg.get_value(pdb.defined_balance_id,c_assignment_action_id),0)
147: from pay_balance_dimensions pbd,
148: pay_defined_balances pdb,

Line 149: pay_balance_types pbt

145: c_dimension_name pay_balance_dimensions.dimension_name%type) is
146: select nvl(pay_balance_pkg.get_value(pdb.defined_balance_id,c_assignment_action_id),0)
147: from pay_balance_dimensions pbd,
148: pay_defined_balances pdb,
149: pay_balance_types pbt
150: where pbt.balance_name = c_balance_name
151: and pbd.dimension_name = c_dimension_name
152: and pbt.balance_type_id = pdb.balance_type_id
153: and pbd.balance_dimension_id = pdb.balance_dimension_id

Line 340: p_balance_name in pay_balance_types.balance_name%type,

336: the view pay_sg_soe_balances_v */
337:
338: procedure current_and_ytd_balances
339: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
340: p_balance_name in pay_balance_types.balance_name%type,
341: p_person_id in per_all_people_f.person_id%type,
342: p_current_balance out nocopy number,
343: p_ytd_balance out nocopy number)
344: is

Line 378: c_balance_name pay_balance_types.balance_name%type,

374:
375: /* Bug:2883606. Cursor to get the balance values from pay_balance_pkg.get_value */
376: cursor balance_value
377: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
378: c_balance_name pay_balance_types.balance_name%type,
379: c_dimension_name pay_balance_dimensions.dimension_name%type) is
380: select nvl(pay_balance_pkg.get_value(pdb.defined_balance_id,c_assignment_action_id),0)
381: from pay_balance_dimensions pbd,
382: pay_defined_balances pdb,

Line 383: pay_balance_types pbt

379: c_dimension_name pay_balance_dimensions.dimension_name%type) is
380: select nvl(pay_balance_pkg.get_value(pdb.defined_balance_id,c_assignment_action_id),0)
381: from pay_balance_dimensions pbd,
382: pay_defined_balances pdb,
383: pay_balance_types pbt
384: where pbt.balance_name = c_balance_name
385: and pbd.dimension_name = c_dimension_name
386: and pbt.balance_type_id = pdb.balance_type_id
387: and pbd.balance_dimension_id = pdb.balance_dimension_id