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_CBS_FILE dependencies on DUAL

Line 445: from dual;

441:
442: cursor csr_get_si_status(p_assignment_id number,
443: p_date date) is
444: select pay_nl_si_pkg.get_si_status(p_assignment_id,p_date,'ZFW')
445: from dual;
446:
447: cursor csr_get_phi_information(p_assignment_id number,
448: p_date date) is
449: SELECT ORG_INFORMATION1 FROM HR_ORGANIZATION_INFORMATION,PER_ASSIGNMENT_EXTRA_INFO PAEI

Line 1325: (select hr_nl_org_info.get_tax_org_id(p_org_struct_version_id,paa.organization_id) from dual)

1321: and asg.effective_start_date <= p_reporting_End_Date
1322: and nvl(asg.effective_end_date, p_reporting_End_Date) >= p_reporting_Start_Date
1323: )
1324: and p_employer_id in
1325: (select hr_nl_org_info.get_tax_org_id(p_org_struct_version_id,paa.organization_id) from dual)
1326: and not exists
1327: (select 1
1328: from
1329: pay_action_information ee_ats

Line 1598: FROM dual;

1594: -- hr_utility.set_location('creating asg_act_id'||l_asg_act_id,600);
1595:
1596: SELECT pay_assignment_actions_s.NEXTVAL
1597: INTO l_asg_act_id
1598: FROM dual;
1599:
1600: -- hr_utility.set_location('new l_asg_act_id'||l_asg_act_id,600);
1601: --
1602: -- Create the archive assignment action