APPS.PAY_NL_REM_REPORT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 754: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;

750: /*******************************************************
751: Variables to Store Organization Details
752: ********************************************************/
753: l_tax_ref_no hr_organization_information.org_information1%TYPE;
754: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
755: l_tax_reg_no hr_organization_information.org_information4%TYPE;
756: l_tax_rep_name hr_organization_information.org_information3%TYPE;
757: l_tax_reg_no1 VARCHAR2(14);
758: l_tax_org_id NUMBER;

Line 816: FROM hr_all_organization_units hrou

812: Cursor to get Business Group Name
813: ***********************************************************/
814: CURSOR cur_get_bg_name IS
815: SELECT hrou.name
816: FROM hr_all_organization_units hrou
817: WHERE hrou.organization_id = p_business_group_id;
818: --=============================================================================
819: /***********************************************************
820: Cursor to fetch employer address

Line 894: FROM hr_all_organization_units hou1

890: CURSOR cur_employer_details IS
891: SELECT DISTINCT
892: hou1.name employer_name
893: ,hou1.organization_id tax_org_id
894: FROM hr_all_organization_units hou1
895: WHERE (
896: nvl (p_sub_emp
897: ,'Y') = 'N'
898: AND hou1.organization_id = nvl (p_top_org_id

Line 1011: ,hr_all_organization_units hou1

1007: ,pay_assignment_actions asg_act
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')

Line 1899: ,hr_all_organization_units hou1

1895: ,per_periods_of_service pps
1896: ,pay_payroll_actions ppa
1897: ,pay_assignment_actions asg_act
1898: ,pay_all_payrolls_f ppf
1899: ,hr_all_organization_units hou1
1900: WHERE ppa.business_group_id = p_business_group_id
1901: AND papf.effective_start_date <= l_reporting_end_date
1902: AND papf.effective_end_date >= l_reporting_start_date
1903: AND papf.current_employee_flag = 'Y'

Line 1936: employer_name hr_all_organization_units.name%TYPE );

1932: hire_date DATE,
1933: end_date DATE,
1934: income NUMBER,
1935: tax NUMBER,
1936: employer_name hr_all_organization_units.name%TYPE );
1937:
1938: TYPE person_details IS TABLE OF person_details_type
1939: INDEX BY BINARY_INTEGER;
1940: