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.PSP_SUM_TRANS dependencies on PER_ASSIGNMENTS_F

Line 1863: per_assignments_f paf,

1859:
1860: CURSOR get_org_id_cur(P_LINE_ID IN NUMBER) IS
1861: SELECT hou.organization_id, hou.name
1862: FROM hr_all_organization_units hou,
1863: per_assignments_f paf,
1864: psp_payroll_lines ppl,
1865: psp_payroll_sub_lines ppsl,
1866: psp_distribution_lines pdl
1867: WHERE pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id

Line 1878: per_assignments_f paf,

1874: hou.date_from and nvl(hou.date_to,pdl.distribution_date)
1875: UNION
1876: SELECT hou.organization_id, hou.name
1877: FROM hr_all_organization_units hou,
1878: per_assignments_f paf,
1879: psp_pre_gen_dist_lines ppgd
1880: WHERE ppgd.pre_gen_dist_line_id = p_line_id
1881: AND ppgd.assignment_id = paf.assignment_id
1882: AND ppgd.distribution_date BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 4357: per_assignments_f paf,

4353:
4354: CURSOR get_org_id_cur1 (P_LINE_ID IN NUMBER) IS
4355: SELECT hou.organization_id, hou.name
4356: FROM hr_all_organization_units hou,
4357: per_assignments_f paf,
4358: psp_payroll_lines ppl,
4359: psp_payroll_sub_lines ppsl,
4360: psp_distribution_lines pdl
4361: WHERE paf.assignment_id = ppl.assignment_id

Line 4370: per_assignments_f paf,

4366: AND pdl.distribution_date between paf.effective_start_date and paf.effective_end_date
4367: UNION
4368: SELECT hou.organization_id, hou.name
4369: FROM hr_all_organization_units hou,
4370: per_assignments_f paf,
4371: psp_pre_gen_dist_lines ppgdl
4372: WHERE paf.assignment_id = ppgdl.assignment_id
4373: AND hou.organization_id = paf.organization_id
4374: AND ppgdl.pre_gen_dist_line_id = p_line_id