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 AP_SELF_ASSESSED_TAX_DIST_ALL

Line 64: AP_SELF_ASSESSED_TAX_DIST_ALL apsat,

60: erl.distribution_line_number distribution_line_number,
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

Line 134: update AP_SELF_ASSESSED_TAX_DIST_ALL

130:
131:
132: and invoice_distribution_id = X_adl_rec.invoice_distribution_id ;
133: /* BUG 14216205 : Added the following Code for SAT : Starts */
134: update AP_SELF_ASSESSED_TAX_DIST_ALL
135: set award_id = X_adl_rec.award_set_id
136: where invoice_id = X_invoice_id
137: and distribution_line_number = X_adl_rec.distribution_line_number
138: and invoice_distribution_id = X_adl_rec.invoice_distribution_id ;

Line 357: from AP_SELF_ASSESSED_TAX_DIST_ALL A,

353: A.creation_date CREATION_DATE,
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

Line 400: update AP_SELF_ASSESSED_TAX_DIST_ALL

396: where invoice_id = loop_ap_rec.invoice_id
397: and distribution_line_number = loop_ap_rec.distribution_line_number
398: and invoice_distribution_id = loop_ap_rec.invoice_distribution_id ;
399: /* BUG 14216205 : Added the following Code for SAT : Starts */
400: update AP_SELF_ASSESSED_TAX_DIST_ALL
401: set award_id = l_adl_rec.award_set_id
402: where invoice_id = loop_ap_rec.invoice_id
403: and DISTRIBUTION_LINE_NUMBER = LOOP_AP_REC.DISTRIBUTION_LINE_NUMBER
404: and invoice_distribution_id = loop_ap_rec.invoice_distribution_id ;

Line 427: update AP_SELF_ASSESSED_TAX_DIST_ALL

423:
424:
425: and invoice_distribution_id = p_invoice_distribution_id ;
426: /* BUG 14216205 : Added the following Code for SAT : Starts */
427: update AP_SELF_ASSESSED_TAX_DIST_ALL
428: set award_id = l_adl_rec.award_set_id
429: where invoice_id = p_invoice_id
430: and distribution_line_number = p_distribution_line_number
431: and invoice_distribution_id = p_invoice_distribution_id ;

Line 575: from AP_SELF_ASSESSED_TAX_DIST_ALL

571: from ap_invoice_distributions_all
572: where Invoice_distribution_id = p_prepay_dist_id
573: union /* BUG 14216205 : Added the union for SAT */
574: select award_id
575: from AP_SELF_ASSESSED_TAX_DIST_ALL
576: where INVOICE_DISTRIBUTION_ID = P_PREPAY_DIST_ID
577: AND LINE_TYPE_LOOKUP_CODE='NONREC_TAX';
578: Cursor C_adl is
579: select *

Line 636: Update AP_SELF_ASSESSED_TAX_DIST_ALL

632: Update ap_invoice_distributions_all
633: Set award_id = x_adl_rec.award_set_id
634: Where invoice_distribution_id = x_inv_dist_id ;
635: /* BUG 14216205 : Added the following Code for SAT : Starts */
636: Update AP_SELF_ASSESSED_TAX_DIST_ALL
637: set AWARD_ID = X_ADL_REC.AWARD_SET_ID
638: where INVOICE_DISTRIBUTION_ID = X_INV_DIST_ID ;
639: /* BUG 14216205 : Added the following Code for SAT : Ends */
640: gms_cost_plus_extn.CALC_prepayment_burden( X_AP_REC, x_adl_rec) ;