APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 6257: ,PER_ASSIGNMENT_STATUS_TYPES ast

6253: CURSOR csr_ass_start_date(c_assignment_id NUMBER) IS
6254: SELECT min(effective_start_date)
6255: --,decode(max(effective_end_date),to_date('31-12-4712','dd-mm-yyyy'),null,max(effective_end_date))
6256: FROM per_all_assignments_F paaf
6257: ,PER_ASSIGNMENT_STATUS_TYPES ast
6258: WHERE paaf.assignment_id = c_assignment_id
6259: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
6260: AND ast.per_system_status = 'ACTIVE_ASSIGN';
6261: --

Line 6265: ,PER_ASSIGNMENT_STATUS_TYPES ast

6261: --
6262: CURSOR csr_ass_end_date(c_assignment_id NUMBER) IS
6263: SELECT decode(max(effective_end_date),to_date('31-12-4712','dd-mm-yyyy'),null,max(effective_end_date))
6264: FROM per_all_assignments_F paaf
6265: ,PER_ASSIGNMENT_STATUS_TYPES ast
6266: WHERE paaf.assignment_id = c_assignment_id
6267: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
6268: AND ast.per_system_status <> 'TERM_ASSIGN';
6269: --

Line 6273: ,PER_ASSIGNMENT_STATUS_TYPES ast

6269: --
6270: CURSOR csr_ass_end_date2(c_assignment_id NUMBER) IS
6271: SELECT min(effective_start_date)
6272: FROM per_all_assignments_F paaf
6273: ,PER_ASSIGNMENT_STATUS_TYPES ast
6274: WHERE paaf.assignment_id = c_assignment_id
6275: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
6276: AND ast.per_system_status = 'TERM_ASSIGN';
6277: --

Line 8544: ,PER_ASSIGNMENT_STATUS_TYPES ast

8540: CURSOR csr_ass_start_date(c_assignment_id NUMBER) IS
8541: SELECT min(effective_start_date)
8542: --,decode(max(effective_end_date),to_date('31-12-4712','dd-mm-yyyy'),null,max(effective_end_date))
8543: FROM per_all_assignments_F paaf
8544: ,PER_ASSIGNMENT_STATUS_TYPES ast
8545: WHERE paaf.assignment_id = c_assignment_id
8546: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
8547: AND ast.per_system_status = 'ACTIVE_ASSIGN';
8548: --

Line 8552: ,PER_ASSIGNMENT_STATUS_TYPES ast

8548: --
8549: CURSOR csr_ass_end_date(c_assignment_id NUMBER) IS
8550: SELECT decode(max(effective_end_date),to_date('31-12-4712','dd-mm-yyyy'),null,max(effective_end_date))
8551: FROM per_all_assignments_F paaf
8552: ,PER_ASSIGNMENT_STATUS_TYPES ast
8553: WHERE paaf.assignment_id = c_assignment_id
8554: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
8555: AND ast.per_system_status <> 'TERM_ASSIGN';
8556: --

Line 8560: ,PER_ASSIGNMENT_STATUS_TYPES ast

8556: --
8557: CURSOR csr_ass_end_date2(c_assignment_id NUMBER) IS
8558: SELECT min(effective_start_date)
8559: FROM per_all_assignments_F paaf
8560: ,PER_ASSIGNMENT_STATUS_TYPES ast
8561: WHERE paaf.assignment_id = c_assignment_id
8562: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
8563: AND ast.per_system_status = 'TERM_ASSIGN';
8564: --