eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_WAGE_REPORT_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2516: l_business_group_id hr_all_organization_units.business_group_id%TYPE;

2512: l_end_date DATE;
2513: l_seq_no VARCHAR2(50);
2514: l_tax_unit_id NUMBER;
2515: l_payroll_type VARCHAR2(80);
2516: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
2517: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
2518: l_risk_cover_flag hr_lookups.lookup_type%TYPE;
2519: l_date DATE;
2520: --

Line 2517: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;

2513: l_seq_no VARCHAR2(50);
2514: l_tax_unit_id NUMBER;
2515: l_payroll_type VARCHAR2(80);
2516: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
2517: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
2518: l_risk_cover_flag hr_lookups.lookup_type%TYPE;
2519: l_date DATE;
2520: --
2521: BEGIN

Line 2593: l_business_group_id hr_all_organization_units.business_group_id%type;

2589: IS
2590: -- DECLARE LOCAL VARIABLES
2591: l_ovn pay_action_information.object_version_number%type;
2592: l_action_info_id pay_action_information.action_information_id%type;
2593: l_business_group_id hr_all_organization_units.business_group_id%type;
2594: l_start_date DATE;
2595: l_end_date DATE;
2596: l_seq_no VARCHAR2(50);
2597: l_emp_total number;

Line 2661: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;

2657: l_exception_flag VARCHAR2(1);
2658: l_awf VARCHAR2(1);
2659: l_tax_ref_no hr_organization_information.org_information1%TYPE;
2660: l_tax_rep_name hr_organization_information.org_information3%TYPE;
2661: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
2662: --#
2663: --
2664: --
2665: --csr_employer_info_rec csr_employer_info%ROWTYPE;

Line 2754: l_business_group_id hr_all_organization_units.business_group_id%type;

2750: IS
2751: -- DECLARE LOCAL VARIABLES
2752: l_ovn pay_action_information.object_version_number%type;
2753: l_action_info_id pay_action_information.action_information_id%type;
2754: l_business_group_id hr_all_organization_units.business_group_id%type;
2755: l_start_date DATE;
2756: l_end_date DATE;
2757: l_seq_no VARCHAR2(50);
2758: l_emp_total number;

Line 2919: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;

2915: l_exception_flag VARCHAR2(1);
2916: l_awf VARCHAR2(1);
2917: l_tax_ref_no hr_organization_information.org_information1%TYPE;
2918: l_tax_rep_name hr_organization_information.org_information3%TYPE;
2919: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
2920: --#
2921: --
2922: CURSOR csr_get_pactid IS
2923: SELECT DISTINCT paa1.payroll_action_id

Line 4374: l_legal_employer hr_all_organization_units.organization_id%type;

4370: AND hou.organization_id = hoi.organization_id
4371: AND hou.organization_id = c_employer_id;
4372: --
4373: l_actid NUMBER;
4374: l_legal_employer hr_all_organization_units.organization_id%type;
4375: l_start_date DATE;
4376: l_end_date DATE;
4377: l_business_group_id NUMBER;
4378: l_chk_assignment_id NUMBER;

Line 4382: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;

4378: l_chk_assignment_id NUMBER;
4379: l_payroll_type VARCHAR2(10);
4380: l_seq_no VARCHAR2(15);
4381: l_paid_flag VARCHAR2(15);
4382: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
4383: --
4384: CURSOR csr_persons(stperson NUMBER
4385: ,endperson NUMBER
4386: ,c_start_date DATE