APPS.PA_UTILS dependencies on PER_PERIODS_OF_SERVICE

Line 490: l_final_process_date per_periods_of_service.final_process_date%TYPE;

486: X_Cross_BG_Profile VARCHAR2(2); /* Added local variable for 3194743 */
487: X_business_group_id NUMBER; /* Added local variable for 3194743 */
488:
489: -- bug 11741116 start
490: l_final_process_date per_periods_of_service.final_process_date%TYPE;
491:
492: CURSOR cur_final_process_date (X_person_id NUMBER, X_date DATE) IS
493: SELECT MAX(nvl(final_process_date,to_date('4712/12/31', 'YYYY/MM/DD')))
494: FROM per_periods_of_service

Line 494: FROM per_periods_of_service

490: l_final_process_date per_periods_of_service.final_process_date%TYPE;
491:
492: CURSOR cur_final_process_date (X_person_id NUMBER, X_date DATE) IS
493: SELECT MAX(nvl(final_process_date,to_date('4712/12/31', 'YYYY/MM/DD')))
494: FROM per_periods_of_service
495: WHERE person_id = X_person_id
496: AND nvl(final_process_date,to_date('4712/12/31', 'YYYY/MM/DD')) > = trunc(X_date);
497: -- bug 11741116 end
498: BEGIN

Line 729: l_final_process_date per_periods_of_service.final_process_date%TYPE;

725: l_po_line_id NUMBER;
726: l_po_number VARCHAR2(20);
727: l_po_line_num NUMBER;
728: -- bug 11741116 start
729: l_final_process_date per_periods_of_service.final_process_date%TYPE;
730: l_actual_termination_date per_periods_of_service.actual_termination_date%type; --Bug 13843625
731:
732: CURSOR cur_final_process_date (X_person_id NUMBER, X_date DATE) IS
733: SELECT MAX(nvl(final_process_date,to_date('4712/12/31', 'YYYY/MM/DD')))

Line 730: l_actual_termination_date per_periods_of_service.actual_termination_date%type; --Bug 13843625

726: l_po_number VARCHAR2(20);
727: l_po_line_num NUMBER;
728: -- bug 11741116 start
729: l_final_process_date per_periods_of_service.final_process_date%TYPE;
730: l_actual_termination_date per_periods_of_service.actual_termination_date%type; --Bug 13843625
731:
732: CURSOR cur_final_process_date (X_person_id NUMBER, X_date DATE) IS
733: SELECT MAX(nvl(final_process_date,to_date('4712/12/31', 'YYYY/MM/DD')))
734: FROM per_periods_of_service

Line 734: FROM per_periods_of_service

730: l_actual_termination_date per_periods_of_service.actual_termination_date%type; --Bug 13843625
731:
732: CURSOR cur_final_process_date (X_person_id NUMBER, X_date DATE) IS
733: SELECT MAX(nvl(final_process_date,to_date('4712/12/31', 'YYYY/MM/DD')))
734: FROM per_periods_of_service
735: WHERE person_id = X_person_id
736: AND nvl(final_process_date,to_date('4712/12/31', 'YYYY/MM/DD')) > = trunc(X_date);
737: -- bug 11741116 end
738:

Line 742: FROM per_periods_of_service

738:
739: /* Bug 13843625: Added cursor cur_actual_termination_date */ /*Modified below cursor in reference to BUG#14698048*/
740: CURSOR cur_actual_termination_date (X_person_id NUMBER, X_date DATE) IS
741: SELECT MAX(nvl(actual_termination_date+1,to_date('4712/12/31', 'YYYY/MM/DD')))
742: FROM per_periods_of_service
743: WHERE person_id = X_person_id
744: AND nvl(final_process_date,to_date('4712/12/31', 'YYYY/MM/DD')) > = trunc(X_date);
745:
746: BEGIN

Line 1786: l_final_process_date per_periods_of_service.final_process_date%TYPE;

1782: l_po_number VARCHAR2(20);
1783: l_po_line_num NUMBER;
1784: X_Cross_BG_Profile VARCHAR2(2); /*Bug 6355926*/
1785: -- bug 11741116 start
1786: l_final_process_date per_periods_of_service.final_process_date%TYPE;
1787:
1788: CURSOR cur_final_process_date (X_person_id NUMBER, X_date DATE) IS
1789: SELECT MAX(nvl(final_process_date,to_date('4712/12/31', 'YYYY/MM/DD')))
1790: FROM per_periods_of_service

Line 1790: FROM per_periods_of_service

1786: l_final_process_date per_periods_of_service.final_process_date%TYPE;
1787:
1788: CURSOR cur_final_process_date (X_person_id NUMBER, X_date DATE) IS
1789: SELECT MAX(nvl(final_process_date,to_date('4712/12/31', 'YYYY/MM/DD')))
1790: FROM per_periods_of_service
1791: WHERE person_id = X_person_id
1792: AND nvl(final_process_date,to_date('4712/12/31', 'YYYY/MM/DD')) > = trunc(X_date);
1793: -- bug 11741116 end
1794: