APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 519: ,csr_v_information_type per_assignment_extra_info.information_type%TYPE

515: lr_assignment_info csr_assignment_info%ROWTYPE;
516:
517: CURSOR csr_extra_assignment_info (
518: csr_v_assignment_id per_all_assignments_f.person_id%TYPE
519: ,csr_v_information_type per_assignment_extra_info.information_type%TYPE
520: )
521: IS
522: SELECT *
523: FROM per_assignment_extra_info

Line 523: FROM per_assignment_extra_info

519: ,csr_v_information_type per_assignment_extra_info.information_type%TYPE
520: )
521: IS
522: SELECT *
523: FROM per_assignment_extra_info
524: WHERE assignment_id = csr_v_assignment_id
525: AND information_type = csr_v_information_type;
526:
527: lr_extra_assignment_info csr_extra_assignment_info%ROWTYPE;

Line 531: ,csr_v_year per_assignment_extra_info.aei_information1%TYPE

527: lr_extra_assignment_info csr_extra_assignment_info%ROWTYPE;
528:
529: CURSOR csr_se_wtc_time_worked_info (
530: csr_v_assignment_id per_all_assignments_f.person_id%TYPE
531: ,csr_v_year per_assignment_extra_info.aei_information1%TYPE
532: )
533: IS
534: SELECT *
535: FROM per_assignment_extra_info

Line 535: FROM per_assignment_extra_info

531: ,csr_v_year per_assignment_extra_info.aei_information1%TYPE
532: )
533: IS
534: SELECT *
535: FROM per_assignment_extra_info
536: WHERE assignment_id = csr_v_assignment_id
537: AND information_type = 'SE_WTC_TIME_WORKED_INFO'
538: AND aei_information1 = csr_v_year;
539: