APPS.PAY_IE_PRSI dependencies on PAY_ASSIGNMENT_ACTIONS

Line 58: FROM pay_assignment_actions paa

54: ,p_till_date IN DATE) RETURN number IS
55: CURSOR cur_assignment_action is
56: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
57: paa.assignment_action_id),16))
58: FROM pay_assignment_actions paa
59: ,pay_payroll_actions ppa
60: WHERE paa.assignment_id=p_assignment_id
61: AND paa.payroll_action_id=ppa.payroll_action_id
62: AND ppa.action_type in ('Q','B','R','I','V')

Line 77: l_assignment_action pay_assignment_actions.assignment_action_id%type;

73: AND pbd.dimension_name =p_dimension_name
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;