APPS.PAY_NL_REM_REPORT dependencies on PER_ALL_PEOPLE_F

Line 848: CURSOR cur_emp_address(c_person_id per_all_people_f.person_id%TYPE) IS

844: WHERE hou.business_group_id = p_business_group_id
845: AND hou.organization_id = l_tax_org_id
846: AND hlc.location_id = hou.location_id;
847: --=============================================================================
848: CURSOR cur_emp_address(c_person_id per_all_people_f.person_id%TYPE) IS
849: SELECT pad.add_information13 house_number
850: ,pad.add_information14 house_no_add
851: ,pad.region_1 street_name
852: ,pad.address_line1 address_line1

Line 1012: ,per_all_people_f papf

1008: ,per_assignments_f paa
1009: ,pay_all_payrolls_f ppf
1010: ,per_periods_of_service pps
1011: ,hr_all_organization_units hou1
1012: ,per_all_people_f papf
1013: WHERE ppa.business_group_id = p_business_group_id
1014: AND ppa.action_type IN ('R','B','I'
1015: ,'Q','V')
1016: AND ppa.action_status = 'C'

Line 1819: l_prev_sofi_number per_all_people_f.national_identifier%TYPE := -9999;

1815: l_income NUMBER := 0;
1816: l_tax_total NUMBER := 0;
1817: l_seperator VARCHAR2(10):= ',';
1818: l_format VARCHAR2(30) := 'FM9999999990D00';
1819: l_prev_sofi_number per_all_people_f.national_identifier%TYPE := -9999;
1820: l_multiple_index NUMBER :=0;
1821: l_per_index NUMBER :=0;
1822: i NUMBER := 0;
1823: l_prev_rank NUMBER := 0;

Line 1832: FROM per_all_people_f papf

1828: ***********************************************************/
1829: CURSOR csr_person_details IS
1830: SELECT DISTINCT
1831: papf.national_identifier sofi_number
1832: FROM per_all_people_f papf
1833: ,per_all_assignments_f paa
1834: ,per_periods_of_service pps
1835: ,pay_payroll_actions ppa
1836: ,pay_assignment_actions asg_act

Line 1864: CURSOR csr_other_emp_details(c_sofi_number per_all_people_f.national_identifier%TYPE) IS

1860: --=============================================================================
1861: /***********************************************************
1862: Cursor to fetch Employee in Cross Employers Details
1863: ***********************************************************/
1864: CURSOR csr_other_emp_details(c_sofi_number per_all_people_f.national_identifier%TYPE) IS
1865: SELECT employee_number,
1866: employee_name,
1867: sofi_number,
1868: hire_date,

Line 1893: FROM per_all_people_f papf

1889: ,paa.person_id person_id
1890: ,NVL (paa.establishment_id
1891: ,ppf.prl_information1) org_id
1892: , REPLACE(hou1.name,l_seperator,' ') employer_name
1893: FROM per_all_people_f papf
1894: ,per_all_assignments_f paa
1895: ,per_periods_of_service pps
1896: ,pay_payroll_actions ppa
1897: ,pay_assignment_actions asg_act

Line 1929: employee_number per_all_people_f.employee_number%TYPE,

1925: --=============================================================================
1926:
1927: r_person_details csr_person_details%ROWTYPE;
1928: TYPE person_details_type IS RECORD (
1929: employee_number per_all_people_f.employee_number%TYPE,
1930: employee_name per_all_people_f.full_name%TYPE,
1931: sofi_number per_all_people_f.national_identifier%TYPE,
1932: hire_date DATE,
1933: end_date DATE,

Line 1930: employee_name per_all_people_f.full_name%TYPE,

1926:
1927: r_person_details csr_person_details%ROWTYPE;
1928: TYPE person_details_type IS RECORD (
1929: employee_number per_all_people_f.employee_number%TYPE,
1930: employee_name per_all_people_f.full_name%TYPE,
1931: sofi_number per_all_people_f.national_identifier%TYPE,
1932: hire_date DATE,
1933: end_date DATE,
1934: income NUMBER,

Line 1931: sofi_number per_all_people_f.national_identifier%TYPE,

1927: r_person_details csr_person_details%ROWTYPE;
1928: TYPE person_details_type IS RECORD (
1929: employee_number per_all_people_f.employee_number%TYPE,
1930: employee_name per_all_people_f.full_name%TYPE,
1931: sofi_number per_all_people_f.national_identifier%TYPE,
1932: hire_date DATE,
1933: end_date DATE,
1934: income NUMBER,
1935: tax NUMBER,