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

Line 739: per_assignments_f paf,

735: SUM(pesl.summary_amount),
736: COUNT(1)
737: FROM psp_enc_summary_lines pesl,
738: psp_enc_controls pec,
739: per_assignments_f paf,
740: per_people_f ppf
741: WHERE pesl.enc_control_id = pec.enc_control_id
742: AND paf.assignment_id = pesl.assignment_id
743: AND pesl.effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 1313: per_assignments_f paf,

1309: SUM(pesl.summary_amount),
1310: COUNT(1)
1311: FROM psp_enc_summary_lines pesl,
1312: psp_enc_controls pec,
1313: per_assignments_f paf,
1314: per_people_f ppf
1315: WHERE pesl.enc_control_id = pec.enc_control_id
1316: AND paf.assignment_id = pesl.assignment_id
1317: AND pesl.effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 3447: per_assignments_f paf,

3443: /***** Commented for bug fix 4625734
3444: CURSOR get_org_id_cur(P_LINE_ID IN NUMBER) IS
3445: SELECT hou.organization_id, hou.name
3446: FROM hr_all_organization_units hou,
3447: per_assignments_f paf,
3448: psp_enc_summary_lines pel
3449: WHERE pel.enc_summary_line_id = p_line_id
3450: AND pel.enc_control_id=p_enc_control_id
3451: -- AND pel.assignment_id = paf.assignment_id

Line 3476: per_assignments_f paf,

3472: pel.effective_date,
3473: pel.attribute30,
3474: pel.gl_code_combination_id
3475: FROM hr_all_organization_units hou,
3476: per_assignments_f paf,
3477: psp_enc_summary_lines pel
3478: WHERE pel.enc_control_id = p_enc_control_id
3479: AND pel.gl_project_flag = 'G'
3480: AND pel.status_code = 'A'

Line 6120: per_assignments_f paf,

6116: /***** Commented the following cursor as it isnt used in the procedure (for bug fix 4625734)
6117: CURSOR get_org_id_cur(P_LINE_ID IN NUMBER) IS
6118: SELECT hou.organization_id, hou.name
6119: FROM hr_all_organization_units hou,
6120: per_assignments_f paf,
6121: psp_enc_summary_lines pel
6122: WHERE pel.enc_summary_line_id = p_line_id
6123: AND pel.enc_control_id=p_enc_control_id
6124: -- AND pel.assignment_id = paf.assignment_id

Line 6147: per_assignments_f paf,

6143: pel.assignment_id,
6144: pel.effective_date,
6145: pel.attribute30
6146: FROM hr_all_organization_units hou,
6147: per_assignments_f paf,
6148: psp_enc_summary_lines pel
6149: WHERE pel.enc_control_id = p_enc_control_id
6150: AND pel.gl_project_flag = 'P'
6151: AND pel.status_code = 'A'