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_IE_P60XML dependencies on HR_ALL_ORGANIZATION_UNITS

Line 504: hr_all_organization_units

500: CURSOR csr_org_name(p_business_group_id number, p_asg_org_id number, cp_effective_date date)
501: IS
502: Select NVL (TRIM (RPAD (NAME, 30)), ' ') asg_org_name
503: FROM
504: hr_all_organization_units
505: where
506: business_group_id = p_business_group_id
507: and organization_id = p_asg_org_id
508: and cp_effective_date between DATE_FROM and NVL(DATE_TO,to_date('31-12-4712','dd-mm-rrrr'));

Line 510: l_asg_org_name hr_all_organization_units.name%type;

506: business_group_id = p_business_group_id
507: and organization_id = p_asg_org_id
508: and cp_effective_date between DATE_FROM and NVL(DATE_TO,to_date('31-12-4712','dd-mm-rrrr'));
509:
510: l_asg_org_name hr_all_organization_units.name%type;
511: --11674153
512:
513: begin
514: hr_utility.set_location('Entering get_p60_details',10);