372: AND pdb.defined_balance_id = c_defined_balance_id;
373:
374: cursor pact_effective_date( c_assignment_action_id in number ) is
375: SELECT ppa.payroll_action_id, ppa.effective_date
376: FROM pay_payroll_actions ppa, pay_assignment_actions paa
377: WHERE ppa.payroll_action_id = paa.payroll_action_id
378: AND paa.assignment_action_id = c_assignment_action_id;
379:
380: BEGIN
653: )
654: IS
655: l_start_date DATE := NULL ;
656: l_date_earned DATE;
657: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
658:
659: CURSOR get_date_earned
660: IS
661: SELECT ppa.date_earned,paa.assignment_id
660: IS
661: SELECT ppa.date_earned,paa.assignment_id
662: FROM
663: pay_payroll_actions ppa,
664: pay_assignment_actions paa
665: WHERE paa.assignment_action_id = p_asg_action
666: AND ppa.payroll_action_id=paa.payroll_action_id;
667:
668: BEGIN