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 739: FROM gl_period_statuses PER,

735: D.org_id, -- org_id
736: NULL, --result_code
737: NULL, --status_code
738: 'N' self_assessed_flag --self_assessed_flag --bug7109594
739: FROM gl_period_statuses PER,
740: ap_invoices I,
741: ap_invoice_distributions_all D,
742: ap_invoice_lines L
743: WHERE D.invoice_id = I.invoice_id

Line 784: FROM gl_period_statuses PER,

780: D.org_id, -- org_id
781: NULL, --result_code
782: NULL, --status_code
783: 'N' self_assessed_flag --self_assessed_flag --bug7109594
784: FROM gl_period_statuses PER,
785: ap_invoices I,
786: ap_invoice_distributions_all D,
787: ap_invoice_lines L,
788: po_distributions_all pod

Line 852: FROM gl_period_statuses PER,

848: T.org_id, -- org_id
849: NULL, --result_code
850: NULL, --status_code
851: T.self_assessed_flag --self_assessed_flag --bug7109594
852: FROM gl_period_statuses PER,
853: ap_invoices I,
854: ap_self_assessed_tax_dist_all T
855: WHERE T.invoice_id = I.invoice_id
856: AND T.posted_flag in ('N', 'P')

Line 893: FROM gl_period_statuses PER,

889: T.org_id, -- org_id
890: NULL, --result_code
891: NULL, --status_code
892: T.self_assessed_flag --self_assessed_flag --bug7109594
893: FROM gl_period_statuses PER,
894: ap_invoices I,
895: ap_self_assessed_tax_dist_all T
896: WHERE T.invoice_id = I.invoice_id
897: AND T.posted_flag in ('N', 'P')

Line 2677: gl_period_statuses per

2673: 'N' self_assessed_flag --self_assessed_flag --bug7109594
2674: FROM ap_invoice_distributions_all aid,
2675: ap_invoices_all ai,
2676: ap_invoice_lines_all ail,
2677: gl_period_statuses per
2678: WHERE ai.invoice_id = p_invoice_id
2679: AND aid.invoice_id = ai.invoice_id
2680: AND ail.invoice_id = aid.invoice_id
2681: AND ail.line_number = aid.invoice_line_number

Line 2715: gl_period_statuses per,

2711: 'N' self_assessed_flag -- self_assessed_flag --bug7109594
2712: FROM ap_invoice_distributions_all aid,
2713: ap_invoices_all ai,
2714: ap_invoice_lines_all ail,
2715: gl_period_statuses per,
2716: po_distributions_all pod
2717: WHERE ai.invoice_id = p_invoice_id
2718: AND aid.invoice_id = ai.invoice_id
2719: AND ail.invoice_id = aid.invoice_id

Line 2775: gl_period_statuses per

2771: NULL, --status_code
2772: T.self_assessed_flag --self_assessed_flag --bug7109594
2773: FROM ap_self_assessed_tax_dist_all t,
2774: ap_invoices_all ai,
2775: gl_period_statuses per
2776: WHERE ai.invoice_id = p_invoice_id
2777: AND t.invoice_id = ai.invoice_id
2778: AND (p_inv_line_num IS NULL OR
2779: (p_inv_line_num IS NOT NULL

Line 2809: gl_period_statuses per

2805: NULL, -- status_code
2806: T.self_assessed_flag -- self_assessed_flag --bug7109594
2807: FROM ap_self_assessed_tax_dist_all t,
2808: ap_invoices_all ai,
2809: gl_period_statuses per
2810: WHERE ai.invoice_id = p_invoice_id
2811: AND t.invoice_id = ai.invoice_id
2812: AND (p_inv_line_num IS NULL OR
2813: (p_inv_line_num IS NOT NULL