APPS.PAY_IE_PRSI dependencies on PAY_DEFINED_BALANCES

Line 69: ,pay_defined_balances pdb

65: AND ppa.effective_date<= p_till_date;
66: CURSOR cur_defined_balance_id is
67: SELECT pdb.defined_balance_id
68: FROM pay_balance_dimensions pbd
69: ,pay_defined_balances pdb
70: ,pay_balance_types pbt
71: WHERE pbt.balance_name = p_balance_name
72: AND pbt.legislation_code='IE'
73: AND pbd.dimension_name =p_dimension_name

Line 78: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

74: AND pbd.legislation_code='IE'
75: AND pdb.balance_dimension_id=pbd.balance_dimension_id
76: AND pdb.balance_type_id=pbt.balance_type_id;
77: l_assignment_action pay_assignment_actions.assignment_action_id%type;
78: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
79: l_balance_value NUMBER:=0;
80: BEGIN
81: OPEN cur_assignment_action;
82: FETCH cur_assignment_action INTO l_assignment_action;