APPS.PAY_SE_ARCHIVE_CWCA dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 420: ,csr_v_information_type per_assignment_extra_info.information_type%TYPE

416:
417:
418: CURSOR csr_extra_assignment_info (
419: csr_v_assignment_id per_all_assignments_f.person_id%TYPE
420: ,csr_v_information_type per_assignment_extra_info.information_type%TYPE
421: )
422: IS
423: SELECT *
424: FROM per_assignment_extra_info

Line 424: FROM per_assignment_extra_info

420: ,csr_v_information_type per_assignment_extra_info.information_type%TYPE
421: )
422: IS
423: SELECT *
424: FROM per_assignment_extra_info
425: WHERE assignment_id = csr_v_assignment_id
426: AND information_type = csr_v_information_type;
427:
428: lr_extra_assignment_info csr_extra_assignment_info%ROWTYPE;

Line 433: ,csr_v_year per_assignment_extra_info.aei_information2%TYPE

429:
430:
431: CURSOR csr_se_wtc_time_worked_info (
432: csr_v_assignment_id per_all_assignments_f.person_id%TYPE
433: ,csr_v_year per_assignment_extra_info.aei_information2%TYPE
434: ,csr_v_month per_assignment_extra_info.aei_information3%TYPE
435: )
436: IS
437: SELECT *

Line 434: ,csr_v_month per_assignment_extra_info.aei_information3%TYPE

430:
431: CURSOR csr_se_wtc_time_worked_info (
432: csr_v_assignment_id per_all_assignments_f.person_id%TYPE
433: ,csr_v_year per_assignment_extra_info.aei_information2%TYPE
434: ,csr_v_month per_assignment_extra_info.aei_information3%TYPE
435: )
436: IS
437: SELECT *
438: FROM per_assignment_extra_info

Line 438: FROM per_assignment_extra_info

434: ,csr_v_month per_assignment_extra_info.aei_information3%TYPE
435: )
436: IS
437: SELECT *
438: FROM per_assignment_extra_info
439: WHERE assignment_id = csr_v_assignment_id
440: AND information_type = 'SE_WTC_TIME_WORKED_INFO'
441: AND aei_information1 = csr_v_year
442: AND aei_information2 = csr_v_month;