474:
475:
476:
477: cursor get_date_earned is select date_earned
478: from pay_payroll_actions ppa
479: ,pay_assignment_actions paa
480: where paa.assignment_action_id=p_assignment_action_id
481: and paa.payroll_action_id=ppa.payroll_action_id;
482: begin
804: l_end_date date;
805: /* 6470561 */
806:
807: cursor get_date_earned is select date_earned
808: from pay_payroll_actions ppa
809: ,pay_assignment_actions paa
810: where paa.assignment_action_id=p_assignment_action_id
811: and paa.payroll_action_id=ppa.payroll_action_id;
812:
884: l_end_date date;
885:
886: cursor get_date_earned is
887: select date_earned
888: from pay_payroll_actions ppa
889: ,pay_assignment_actions paa
890: where paa.assignment_action_id = p_assignment_action_id
891: and paa.payroll_action_id = ppa.payroll_action_id;
892: