APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 9926: ,PER_ASSIGNMENT_STATUS_TYPES ast

9922: CURSOR csr_ass_start_date(c_assignment_id NUMBER) IS
9923: SELECT min(effective_start_date)
9924: --,decode(max(effective_end_date),to_date('31-12-4712','dd-mm-yyyy'),null,max(effective_end_date))
9925: FROM per_all_assignments_F paaf
9926: ,PER_ASSIGNMENT_STATUS_TYPES ast
9927: WHERE paaf.assignment_id = c_assignment_id
9928: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
9929: AND ast.per_system_status = 'ACTIVE_ASSIGN';
9930: --

Line 9934: ,PER_ASSIGNMENT_STATUS_TYPES ast

9930: --
9931: CURSOR csr_ass_end_date(c_assignment_id NUMBER) IS
9932: SELECT decode(max(effective_end_date),to_date('31-12-4712','dd-mm-yyyy'),null,max(effective_end_date))
9933: FROM per_all_assignments_F paaf
9934: ,PER_ASSIGNMENT_STATUS_TYPES ast
9935: WHERE paaf.assignment_id = c_assignment_id
9936: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
9937: AND ast.per_system_status <> 'TERM_ASSIGN';
9938: --

Line 9942: ,PER_ASSIGNMENT_STATUS_TYPES ast

9938: --
9939: CURSOR csr_ass_end_date2(c_assignment_id NUMBER) IS
9940: SELECT min(effective_start_date)
9941: FROM per_all_assignments_F paaf
9942: ,PER_ASSIGNMENT_STATUS_TYPES ast
9943: WHERE paaf.assignment_id = c_assignment_id
9944: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
9945: AND ast.per_system_status = 'TERM_ASSIGN';
9946:

Line 14134: ,PER_ASSIGNMENT_STATUS_TYPES ast

14130: CURSOR csr_ass_start_date(c_assignment_id NUMBER) IS
14131: SELECT min(effective_start_date)
14132: --,decode(max(effective_end_date),to_date('31-12-4712','dd-mm-yyyy'),null,max(effective_end_date))
14133: FROM per_all_assignments_F paaf
14134: ,PER_ASSIGNMENT_STATUS_TYPES ast
14135: WHERE paaf.assignment_id = c_assignment_id
14136: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
14137: AND ast.per_system_status = 'ACTIVE_ASSIGN';
14138: --

Line 14142: ,PER_ASSIGNMENT_STATUS_TYPES ast

14138: --
14139: CURSOR csr_ass_end_date(c_assignment_id NUMBER) IS
14140: SELECT decode(max(effective_end_date),to_date('31-12-4712','dd-mm-yyyy'),null,max(effective_end_date))
14141: FROM per_all_assignments_F paaf
14142: ,PER_ASSIGNMENT_STATUS_TYPES ast
14143: WHERE paaf.assignment_id = c_assignment_id
14144: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
14145: AND ast.per_system_status <> 'TERM_ASSIGN';
14146: --

Line 14150: ,PER_ASSIGNMENT_STATUS_TYPES ast

14146: --
14147: CURSOR csr_ass_end_date2(c_assignment_id NUMBER) IS
14148: SELECT min(effective_start_date)
14149: FROM per_all_assignments_F paaf
14150: ,PER_ASSIGNMENT_STATUS_TYPES ast
14151: WHERE paaf.assignment_id = c_assignment_id
14152: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
14153: AND ast.per_system_status = 'TERM_ASSIGN';
14154: --