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_ENC_SUM_TRAN dependencies on PER_ASSIGNMENTS_F

Line 2776: per_assignments_f paf,

2772: / *
2773: CURSOR get_org_id_cur(P_LINE_ID IN NUMBER) IS
2774: SELECT hou.organization_id, hou.name
2775: FROM hr_all_organization_units hou,
2776: per_assignments_f paf,
2777: psp_enc_lines pel
2778: WHERE pel.enc_summary_line_id = p_line_id
2779: AND pel.assignment_id = paf.assignment_id
2780: AND pel.encumbrance_date BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 2790: per_assignments_f paf,

2786:
2787: CURSOR get_org_id_cur(P_ROWID IN ROWID) IS
2788: SELECT hou.organization_id, hou.name
2789: FROM hr_all_organization_units hou,
2790: per_assignments_f paf,
2791: psp_enc_lines pel
2792: WHERE
2793: -- pel.enc_summary_line_id = p_line_id
2794: pel.rowid=p_rowid

Line 2816: per_assignments_f paf,

2812: pel.encumbrance_date,
2813: pel.suspense_org_account_id,
2814: pel.gl_code_combination_id
2815: FROM hr_organization_units hou,
2816: per_assignments_f paf,
2817: psp_enc_lines pel
2818: WHERE pel.enc_summary_line_id = p_enc_summary_line_id
2819: AND pel.assignment_id = paf.assignment_id
2820: AND pel.encumbrance_date BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 3403: per_assignments_f paf,

3399:
3400: CURSOR get_org_id_cur(P_ROWID IN ROWID) IS
3401: SELECT hou.organization_id, hou.name
3402: FROM hr_all_organization_units hou,
3403: per_assignments_f paf,
3404: psp_enc_lines pel
3405: WHERE pel.rowid=p_rowid
3406: AND pel.assignment_id = paf.assignment_id
3407: AND pel.encumbrance_date BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 5268: per_assignments_f paf,

5264: / *
5265: CURSOR get_org_id_cur(P_LINE_ID IN NUMBER) IS
5266: SELECT hou.organization_id, hou.name
5267: FROM hr_all_organization_units hou,
5268: per_assignments_f paf,
5269: psp_enc_lines pel
5270: WHERE pel.enc_summary_line_id = p_line_id
5271: AND pel.assignment_id = paf.assignment_id
5272: AND pel.encumbrance_date BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 5282: per_assignments_f paf,

5278:
5279: CURSOR get_org_id_cur(P_ROWID IN ROWID) IS
5280: SELECT hou.organization_id, hou.name
5281: FROM hr_all_organization_units hou,
5282: per_assignments_f paf,
5283: psp_enc_lines pel
5284: WHERE
5285: -- pel.enc_summary_line_id = p_line_id
5286: pel.rowid=p_rowid

Line 5307: per_assignments_f paf,

5303: pel.assignment_id,
5304: pel.encumbrance_date,
5305: pel.suspense_org_account_id
5306: FROM hr_organization_units hou,
5307: per_assignments_f paf,
5308: psp_enc_lines pel,
5309: WHERE pel.enc_summary_line_id = p_enc_summary_line_id
5310: AND pel.assignment_id = paf.assignment_id
5311: AND pel.encumbrance_date BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 5977: per_assignments_f paf,

5973:
5974: CURSOR get_org_id_cur(P_ROWID IN ROWID) IS
5975: SELECT hou.organization_id, hou.name
5976: FROM hr_all_organization_units hou,
5977: per_assignments_f paf,
5978: psp_enc_lines pel
5979: WHERE pel.rowid=p_rowid
5980: AND pel.assignment_id = paf.assignment_id
5981: AND pel.encumbrance_date BETWEEN paf.effective_start_date AND paf.effective_end_date