APPS.PAY_SE_INCOME_STATEMENT dependencies on PER_PEOPLE_EXTRA_INFO

Line 1025: ,csr_v_information_type per_people_extra_info.information_type%TYPE

1021: -- *****************************************************************************
1022: -- Income Statement Specification Details
1023: CURSOR csr_person_inc_stmt_spec (
1024: csr_v_person_id NUMBER
1025: ,csr_v_information_type per_people_extra_info.information_type%TYPE
1026: )
1027: IS
1028: SELECT pei_information1
1029: ,pei_information2

Line 1037: FROM per_people_extra_info

1033: ,pei_information6
1034: ,pei_information7
1035: ,pei_information8
1036: ,pei_information9
1037: FROM per_people_extra_info
1038: WHERE person_id = csr_v_person_id
1039: AND information_type = csr_v_information_type;
1040:
1041: lr_person_inc_stmt_spec csr_person_inc_stmt_spec%ROWTYPE;

Line 2043: FROM per_people_extra_info

2039:
2040: CURSOR csr_person_correction_date (csr_v_person_id NUMBER)
2041: IS
2042: SELECT pei_information1
2043: FROM per_people_extra_info
2044: WHERE person_id = csr_v_person_id
2045: AND information_type = 'SE_INC_STMT_DATA_CORRECTION';
2046:
2047: lr_person_correction_date csr_person_correction_date%ROWTYPE;

Line 2291: ,csr_v_information_type per_people_extra_info.information_type%TYPE

2287: -- *****************************************************************************
2288: -- Income Statement Specification Details
2289: CURSOR csr_person_inc_stmt_spec (
2290: csr_v_person_id NUMBER
2291: ,csr_v_information_type per_people_extra_info.information_type%TYPE
2292: )
2293: IS
2294: SELECT pei_information1
2295: ,pei_information2

Line 2303: FROM per_people_extra_info

2299: ,pei_information6
2300: ,pei_information7
2301: ,pei_information8
2302: ,pei_information9
2303: FROM per_people_extra_info
2304: WHERE person_id = csr_v_person_id
2305: AND information_type = csr_v_information_type;
2306:
2307: lr_person_inc_stmt_spec csr_person_inc_stmt_spec%ROWTYPE;