APPS.PAY_SE_INCOME_STATEMENT dependencies on PER_PEOPLE_EXTRA_INFO

Line 1031: ,csr_v_information_type per_people_extra_info.information_type%TYPE

1027: -- *****************************************************************************
1028: -- Income Statement Specification Details
1029: CURSOR csr_person_inc_stmt_spec (
1030: csr_v_person_id NUMBER
1031: ,csr_v_information_type per_people_extra_info.information_type%TYPE
1032: )
1033: IS
1034: SELECT pei_information1
1035: ,pei_information2

Line 1043: FROM per_people_extra_info

1039: ,pei_information6
1040: ,pei_information7
1041: ,pei_information8
1042: ,pei_information9
1043: FROM per_people_extra_info
1044: WHERE person_id = csr_v_person_id
1045: AND information_type = csr_v_information_type;
1046:
1047: lr_person_inc_stmt_spec csr_person_inc_stmt_spec%ROWTYPE;

Line 2058: FROM per_people_extra_info

2054:
2055: CURSOR csr_person_correction_date (csr_v_person_id NUMBER)
2056: IS
2057: SELECT pei_information1
2058: FROM per_people_extra_info
2059: WHERE person_id = csr_v_person_id
2060: AND information_type = 'SE_INC_STMT_DATA_CORRECTION';
2061:
2062: lr_person_correction_date csr_person_correction_date%ROWTYPE;

Line 2306: ,csr_v_information_type per_people_extra_info.information_type%TYPE

2302: -- *****************************************************************************
2303: -- Income Statement Specification Details
2304: CURSOR csr_person_inc_stmt_spec (
2305: csr_v_person_id NUMBER
2306: ,csr_v_information_type per_people_extra_info.information_type%TYPE
2307: )
2308: IS
2309: SELECT pei_information1
2310: ,pei_information2

Line 2318: FROM per_people_extra_info

2314: ,pei_information6
2315: ,pei_information7
2316: ,pei_information8
2317: ,pei_information9
2318: FROM per_people_extra_info
2319: WHERE person_id = csr_v_person_id
2320: AND information_type = csr_v_information_type;
2321:
2322: lr_person_inc_stmt_spec csr_person_inc_stmt_spec%ROWTYPE;