APPS.PAY_AU_PAYSLIP_ARCHIVE dependencies on PAY_AU_ASG_LEAVE_TAKEN_V

Line 668: from pay_au_asg_leave_taken_v1

664: , start_date
665: , end_date
666: , absence_hours
667: , payment
668: from pay_au_asg_leave_taken_v1
669: where time_period_id = p_time_period_id
670: and assignment_id = p_assignment_id;
671:
672:

Line 683: from pay_au_asg_leave_taken_v2

679: , start_date
680: , end_date
681: , absence_hours
682: , payment
683: from pay_au_asg_leave_taken_v2
684: where time_period_id = p_time_period_id
685: and assignment_id = p_assignment_id;
686:
687:

Line 697: from pay_au_asg_leave_taken_v3

693: , start_date
694: , end_date
695: , absence_hours
696: , payment
697: from pay_au_asg_leave_taken_v3
698: where time_period_id = p_time_period_id
699: and assignment_id = p_assignment_id;
700:
701:

Line 711: from pay_au_asg_leave_taken_v4

707: , start_date
708: , end_date
709: , absence_hours
710: , payment
711: from pay_au_asg_leave_taken_v4
712: where time_period_id = p_time_period_id
713: and assignment_id = p_assignment_id;
714:
715:

Line 725: from pay_au_asg_leave_taken_v5

721: , start_date
722: , end_date
723: , absence_hours
724: , payment
725: from pay_au_asg_leave_taken_v5
726: where time_period_id = p_time_period_id
727: and assignment_id = p_assignment_id;
728:
729:

Line 739: type tab_row is table of pay_au_asg_leave_taken_v.row_id%type index by binary_integer;

735: l_procedure varchar2(200);
736: l_start_date VARCHAR2(20);
737: l_end_date VARCHAR2(20);
738:
739: type tab_row is table of pay_au_asg_leave_taken_v.row_id%type index by binary_integer;
740:
741: tab_row_id tab_row;
742:
743: i number ;