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 1753: per_assignments_f paf,

1749:
1750: CURSOR get_org_id_cur(P_LINE_ID IN NUMBER) IS
1751: SELECT hou.organization_id, hou.name
1752: FROM hr_all_organization_units hou,
1753: per_assignments_f paf,
1754: psp_payroll_lines ppl,
1755: psp_payroll_sub_lines ppsl,
1756: psp_distribution_lines pdl
1757: WHERE pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id

Line 1768: per_assignments_f paf,

1764: hou.date_from and nvl(hou.date_to,pdl.distribution_date)
1765: UNION
1766: SELECT hou.organization_id, hou.name
1767: FROM hr_all_organization_units hou,
1768: per_assignments_f paf,
1769: psp_pre_gen_dist_lines ppgd
1770: WHERE ppgd.pre_gen_dist_line_id = p_line_id
1771: AND ppgd.assignment_id = paf.assignment_id
1772: AND ppgd.distribution_date BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 4094: per_assignments_f paf,

4090:
4091: CURSOR get_org_id_cur1 (P_LINE_ID IN NUMBER) IS
4092: SELECT hou.organization_id, hou.name
4093: FROM hr_all_organization_units hou,
4094: per_assignments_f paf,
4095: psp_payroll_lines ppl,
4096: psp_payroll_sub_lines ppsl,
4097: psp_distribution_lines pdl
4098: WHERE paf.assignment_id = ppl.assignment_id

Line 4107: per_assignments_f paf,

4103: AND pdl.distribution_date between paf.effective_start_date and paf.effective_end_date
4104: UNION
4105: SELECT hou.organization_id, hou.name
4106: FROM hr_all_organization_units hou,
4107: per_assignments_f paf,
4108: psp_pre_gen_dist_lines ppgdl
4109: WHERE paf.assignment_id = ppgdl.assignment_id
4110: AND hou.organization_id = paf.organization_id
4111: AND ppgdl.pre_gen_dist_line_id = p_line_id