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

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

Line 1304: per_assignments_f paf,

1300: SUM(pesl.summary_amount),
1301: COUNT(1)
1302: FROM psp_enc_summary_lines pesl,
1303: psp_enc_controls pec,
1304: per_assignments_f paf,
1305: per_people_f ppf
1306: WHERE pesl.enc_control_id = pec.enc_control_id
1307: AND paf.assignment_id = pesl.assignment_id
1308: AND pesl.effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 3390: per_assignments_f paf,

3386: /***** Commented for bug fix 4625734
3387: CURSOR get_org_id_cur(P_LINE_ID IN NUMBER) IS
3388: SELECT hou.organization_id, hou.name
3389: FROM hr_all_organization_units hou,
3390: per_assignments_f paf,
3391: psp_enc_summary_lines pel
3392: WHERE pel.enc_summary_line_id = p_line_id
3393: AND pel.enc_control_id=p_enc_control_id
3394: -- AND pel.assignment_id = paf.assignment_id

Line 3419: per_assignments_f paf,

3415: pel.effective_date,
3416: pel.attribute30,
3417: pel.gl_code_combination_id
3418: FROM hr_all_organization_units hou,
3419: per_assignments_f paf,
3420: psp_enc_summary_lines pel
3421: WHERE pel.enc_control_id = p_enc_control_id
3422: AND pel.gl_project_flag = 'G'
3423: AND pel.status_code = 'A'

Line 5987: per_assignments_f paf,

5983: /***** Commented the following cursor as it isnt used in the procedure (for bug fix 4625734)
5984: CURSOR get_org_id_cur(P_LINE_ID IN NUMBER) IS
5985: SELECT hou.organization_id, hou.name
5986: FROM hr_all_organization_units hou,
5987: per_assignments_f paf,
5988: psp_enc_summary_lines pel
5989: WHERE pel.enc_summary_line_id = p_line_id
5990: AND pel.enc_control_id=p_enc_control_id
5991: -- AND pel.assignment_id = paf.assignment_id

Line 6014: per_assignments_f paf,

6010: pel.assignment_id,
6011: pel.effective_date,
6012: pel.attribute30
6013: FROM hr_all_organization_units hou,
6014: per_assignments_f paf,
6015: psp_enc_summary_lines pel
6016: WHERE pel.enc_control_id = p_enc_control_id
6017: AND pel.gl_project_flag = 'P'
6018: AND pel.status_code = 'A'