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.AP_FUNDS_CONTROL_PKG dependencies on GL_PERIOD_STATUSES

Line 589: FROM gl_period_statuses PER,

585: D.org_id, -- org_id
586: NULL, --result_code
587: NULL, --status_code
588: 'N' self_assessed_flag --self_assessed_flag --bug7109594
589: FROM gl_period_statuses PER,
590: ap_invoices I,
591: ap_invoice_distributions_all D,
592: ap_invoice_lines L
593: WHERE D.invoice_id = I.invoice_id

Line 633: FROM gl_period_statuses PER,

629: D.org_id, -- org_id
630: NULL, --result_code
631: NULL, --status_code
632: 'N' self_assessed_flag --self_assessed_flag --bug7109594
633: FROM gl_period_statuses PER,
634: ap_invoices I,
635: ap_invoice_distributions_all D,
636: ap_invoice_lines L,
637: po_distributions_all pod

Line 700: FROM gl_period_statuses PER,

696: T.org_id, -- org_id
697: NULL, --result_code
698: NULL, --status_code
699: T.self_assessed_flag --self_assessed_flag --bug7109594
700: FROM gl_period_statuses PER,
701: ap_invoices I,
702: ap_self_assessed_tax_dist_all T
703: WHERE T.invoice_id = I.invoice_id
704: AND T.posted_flag in ('N', 'P')

Line 740: FROM gl_period_statuses PER,

736: T.org_id, -- org_id
737: NULL, --result_code
738: NULL, --status_code
739: T.self_assessed_flag --self_assessed_flag --bug7109594
740: FROM gl_period_statuses PER,
741: ap_invoices I,
742: ap_self_assessed_tax_dist_all T
743: WHERE T.invoice_id = I.invoice_id
744: AND T.posted_flag in ('N', 'P')

Line 2272: gl_period_statuses per

2268: 'N' self_assessed_flag --self_assessed_flag --bug7109594
2269: FROM ap_invoice_distributions_all aid,
2270: ap_invoices_all ai,
2271: ap_invoice_lines_all ail,
2272: gl_period_statuses per
2273: WHERE ai.invoice_id = p_invoice_id
2274: AND aid.invoice_id = ai.invoice_id
2275: AND ail.invoice_id = aid.invoice_id
2276: AND ail.line_number = aid.invoice_line_number

Line 2310: gl_period_statuses per,

2306: 'N' self_assessed_flag -- self_assessed_flag --bug7109594
2307: FROM ap_invoice_distributions_all aid,
2308: ap_invoices_all ai,
2309: ap_invoice_lines_all ail,
2310: gl_period_statuses per,
2311: po_distributions_all pod
2312: WHERE ai.invoice_id = p_invoice_id
2313: AND aid.invoice_id = ai.invoice_id
2314: AND ail.invoice_id = aid.invoice_id

Line 2370: gl_period_statuses per

2366: NULL, --status_code
2367: T.self_assessed_flag --self_assessed_flag --bug7109594
2368: FROM ap_self_assessed_tax_dist_all t,
2369: ap_invoices_all ai,
2370: gl_period_statuses per
2371: WHERE ai.invoice_id = p_invoice_id
2372: AND t.invoice_id = ai.invoice_id
2373: AND (p_inv_line_num IS NULL OR
2374: (p_inv_line_num IS NOT NULL

Line 2404: gl_period_statuses per

2400: NULL, -- status_code
2401: T.self_assessed_flag -- self_assessed_flag --bug7109594
2402: FROM ap_self_assessed_tax_dist_all t,
2403: ap_invoices_all ai,
2404: gl_period_statuses per
2405: WHERE ai.invoice_id = p_invoice_id
2406: AND t.invoice_id = ai.invoice_id
2407: AND (p_inv_line_num IS NULL OR
2408: (p_inv_line_num IS NOT NULL