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

2730: / *
2731: CURSOR get_org_id_cur(P_LINE_ID IN NUMBER) IS
2732: SELECT hou.organization_id, hou.name
2733: FROM hr_all_organization_units hou,
2734: per_assignments_f paf,
2735: psp_enc_lines pel
2736: WHERE pel.enc_summary_line_id = p_line_id
2737: AND pel.assignment_id = paf.assignment_id
2738: AND pel.encumbrance_date BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 2748: per_assignments_f paf,

2744:
2745: CURSOR get_org_id_cur(P_ROWID IN ROWID) IS
2746: SELECT hou.organization_id, hou.name
2747: FROM hr_all_organization_units hou,
2748: per_assignments_f paf,
2749: psp_enc_lines pel
2750: WHERE
2751: -- pel.enc_summary_line_id = p_line_id
2752: pel.rowid=p_rowid

Line 2774: per_assignments_f paf,

2770: pel.encumbrance_date,
2771: pel.suspense_org_account_id,
2772: pel.gl_code_combination_id
2773: FROM hr_organization_units hou,
2774: per_assignments_f paf,
2775: psp_enc_lines pel
2776: WHERE pel.enc_summary_line_id = p_enc_summary_line_id
2777: AND pel.assignment_id = paf.assignment_id
2778: AND pel.encumbrance_date BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 3361: per_assignments_f paf,

3357:
3358: CURSOR get_org_id_cur(P_ROWID IN ROWID) IS
3359: SELECT hou.organization_id, hou.name
3360: FROM hr_all_organization_units hou,
3361: per_assignments_f paf,
3362: psp_enc_lines pel
3363: WHERE pel.rowid=p_rowid
3364: AND pel.assignment_id = paf.assignment_id
3365: AND pel.encumbrance_date BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 5085: per_assignments_f paf,

5081: / *
5082: CURSOR get_org_id_cur(P_LINE_ID IN NUMBER) IS
5083: SELECT hou.organization_id, hou.name
5084: FROM hr_all_organization_units hou,
5085: per_assignments_f paf,
5086: psp_enc_lines pel
5087: WHERE pel.enc_summary_line_id = p_line_id
5088: AND pel.assignment_id = paf.assignment_id
5089: AND pel.encumbrance_date BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 5099: per_assignments_f paf,

5095:
5096: CURSOR get_org_id_cur(P_ROWID IN ROWID) IS
5097: SELECT hou.organization_id, hou.name
5098: FROM hr_all_organization_units hou,
5099: per_assignments_f paf,
5100: psp_enc_lines pel
5101: WHERE
5102: -- pel.enc_summary_line_id = p_line_id
5103: pel.rowid=p_rowid

Line 5124: per_assignments_f paf,

5120: pel.assignment_id,
5121: pel.encumbrance_date,
5122: pel.suspense_org_account_id
5123: FROM hr_organization_units hou,
5124: per_assignments_f paf,
5125: psp_enc_lines pel,
5126: WHERE pel.enc_summary_line_id = p_enc_summary_line_id
5127: AND pel.assignment_id = paf.assignment_id
5128: AND pel.encumbrance_date BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 5794: per_assignments_f paf,

5790:
5791: CURSOR get_org_id_cur(P_ROWID IN ROWID) IS
5792: SELECT hou.organization_id, hou.name
5793: FROM hr_all_organization_units hou,
5794: per_assignments_f paf,
5795: psp_enc_lines pel
5796: WHERE pel.rowid=p_rowid
5797: AND pel.assignment_id = paf.assignment_id
5798: AND pel.encumbrance_date BETWEEN paf.effective_start_date AND paf.effective_end_date