DBA Data[Home] [Help]

APPS.PAY_SG_EXC dependencies on PAY_ASSIGNMENT_ACTIONS

Line 396: FROM pay_payroll_actions ppa, pay_assignment_actions paa

392: AND pdb.defined_balance_id = c_defined_balance_id;
393:
394: cursor pact_effective_date( c_assignment_action_id in number ) is
395: SELECT ppa.payroll_action_id, ppa.effective_date
396: FROM pay_payroll_actions ppa, pay_assignment_actions paa
397: WHERE ppa.payroll_action_id = paa.payroll_action_id
398: AND paa.assignment_action_id = c_assignment_action_id;
399:
400: BEGIN