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.GMS_AP_API dependencies on PA_PROJECTS_ALL

Line 44: pa_projects_all p,

40: apd.invoice_distribution_id invoice_distribution_id,
41: apd.award_id award_set_id
42: from ap_expense_report_lines_all erl,
43: ap_invoice_distributions_all apd,
44: pa_projects_all p,
45: gms_project_types gpt
46: where report_header_id = X_report_header_id
47: and erl.distribution_line_number= apd.distribution_line_number
48: and apd.invoice_id = X_invoice_id

Line 65: pa_projects_all p,

61: apsat.invoice_distribution_id invoice_distribution_id,
62: apsat.award_id award_set_id
63: from AP_EXPENSE_REPORT_LINES_ALL ERL,
64: AP_SELF_ASSESSED_TAX_DIST_ALL apsat,
65: pa_projects_all p,
66: GMS_PROJECT_TYPES GPT
67: where report_header_id = X_report_header_id
68: and ERL.DISTRIBUTION_LINE_NUMBER= APSAT.DISTRIBUTION_LINE_NUMBER
69: and apsat.invoice_id = X_invoice_id

Line 338: pa_projects_all B,

334: A.last_updated_by LAST_UPDATED_BY,
335: A.created_by CREATED_BY,
336: A.last_update_login LAST_UPDATE_LOGIN
337: from ap_invoice_distributions_all A,
338: pa_projects_all B,
339: gms_project_types C
340: where invoice_id = p_invoice_id
341: and distribution_line_number = p_distribution_line_number
342: and invoice_distribution_id = p_invoice_distribution_id

Line 358: pa_projects_all B,

354: A.last_updated_by LAST_UPDATED_BY,
355: A.created_by CREATED_BY,
356: A.last_update_login LAST_UPDATE_LOGIN
357: from AP_SELF_ASSESSED_TAX_DIST_ALL A,
358: pa_projects_all B,
359: gms_project_types C
360: where invoice_id = p_invoice_id
361: and distribution_line_number = p_distribution_line_number
362: and invoice_distribution_id = p_invoice_distribution_id

Line 832: pa_projects_all p,

828: A.created_by CREATED_BY,
829: NVL(A.last_update_login,0) LAST_UPDATE_LOGIN,
830: inv.invoice_num invoice_num
831: from ap_invoice_distributions_all A,
832: pa_projects_all p,
833: gms_project_types gpt,
834: ap_invoices_all inv
835: where a.invoice_id = p_invoice_id
836: and a.project_id = p.project_id

Line 849: pa_projects_all p,

845:
846: cursor c2 is
847: SELECT 1
848: from ap_invoice_distributions_all A,
849: pa_projects_all p,
850: gms_project_types gpt
851: where a.invoice_id = p_invoice_id
852: and a.project_id = p.project_id
853: and p.project_type = gpt.project_type

Line 973: -- pa_projects_all p,

969: -- where apd.invoice_id = p_invoice_id
970: -- and apd.award_id is not NULL
971: -- and apd.invoice_distribution_id in ( select a.invoice_distribution_id
972: -- from ap_invoice_distributions_all A,
973: -- pa_projects_all p,
974: -- gms_project_types gpt
975: -- where a.invoice_id = p_invoice_id
976: -- and a.project_id = p.project_id
977: -- and p.project_type = gpt.project_type

Line 986: pa_projects_all p,

982: */
983: select a.invoice_distribution_id
984: bulk collect into l_dummy_tab
985: from ap_invoice_distributions_all A,
986: pa_projects_all p,
987: gms_project_types gpt
988: where a.invoice_id = p_invoice_id
989: and a.project_id = p.project_id
990: and a.award_id is not NULL