APPS.PAY_AU_PAYSLIP_ARCHIVE dependencies on PAY_AU_ASG_LEAVE_TAKEN_V

Line 678: from pay_au_asg_leave_taken_v1

674: , start_date
675: , end_date
676: , absence_hours
677: , payment
678: from pay_au_asg_leave_taken_v1
679: where time_period_id = p_time_period_id
680: and assignment_id = p_assignment_id
681: and action_type IN ('R','Q','V');
682:

Line 694: from pay_au_asg_leave_taken_v2

690: , start_date
691: , end_date
692: , absence_hours
693: , payment
694: from pay_au_asg_leave_taken_v2
695: where time_period_id = p_time_period_id
696: and assignment_id = p_assignment_id
697: and action_type IN ('R','Q','V');
698:

Line 709: from pay_au_asg_leave_taken_v3

705: , start_date
706: , end_date
707: , absence_hours
708: , payment
709: from pay_au_asg_leave_taken_v3
710: where time_period_id = p_time_period_id
711: and assignment_id = p_assignment_id
712: and action_type IN ('R','Q','V');
713:

Line 724: from pay_au_asg_leave_taken_v4

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

Line 738: from pay_au_asg_leave_taken_v5

734: , start_date
735: , end_date
736: , absence_hours
737: , payment
738: from pay_au_asg_leave_taken_v5
739: where time_period_id = p_time_period_id
740: and assignment_id = p_assignment_id
741: and action_type IN ('R','Q','V');
742:

Line 752: from pay_au_asg_leave_taken_v6

748: , start_date
749: , end_date
750: , absence_hours
751: , payment
752: from pay_au_asg_leave_taken_v6
753: where time_period_id = p_time_period_id
754: and assignment_id = p_assignment_id
755: and action_type IN ('R','Q','V');
756:

Line 766: from pay_au_asg_leave_taken_v7

762: , start_date
763: , end_date
764: , absence_hours
765: , payment
766: from pay_au_asg_leave_taken_v7
767: where time_period_id = p_time_period_id
768: and assignment_id = p_assignment_id
769: and action_type IN ('R','Q','V');
770:

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

776: l_procedure varchar2(200);
777: l_start_date VARCHAR2(20);
778: l_end_date VARCHAR2(20);
779:
780: type tab_row is table of pay_au_asg_leave_taken_v.row_id%type index by binary_integer;
781:
782: tab_row_id tab_row;
783:
784: i number ;