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

Line 275: /* GL_PERIOD_STATUSES */

271: /* GL_BC_PERIOD_MAP */
272: /* GL_BC_DUAL */
273: /* GL_BC_DUAL2 */
274: /* GL_CONCURRENCY_CONTROL */
275: /* GL_PERIOD_STATUSES */
276: /* GL_LOOKUPS */
277: /* GL_USSGL_TRANSACTION_CODES */
278: /* GL_USSGL_ACCOUNT_PAIRS */
279: /* GL_BALANCES */

Line 2678: gl_period_statuses ps

2674: and bo.range_id(+) = ba.range_id
2675: and bo.funding_budget_version_id
2676: in (select BV1.budget_version_id
2677: from gl_budget_versions bv1, gl_budgets b,
2678: gl_period_statuses ps
2679: where ba.ledger_id = g_ledger_id
2680: and ba.currency_code = bp.currency_code
2681: and ba.code_combination_id = bp.code_combination_id
2682: and b.budget_name = bv1.budget_name

Line 2693: from gl_period_statuses p1

2689: and ps.ledger_id = g_ledger_id
2690: and ps.period_name = bp.period_name
2691: and ps.start_date
2692: >= (select p1.start_date
2693: from gl_period_statuses p1
2694: where p1.period_name = b.first_valid_period_name
2695: and p1.application_id = ps.application_id
2696: and p1.ledger_id = ps.ledger_id)
2697: and ps.end_date

Line 2699: from gl_period_statuses p2

2695: and p1.application_id = ps.application_id
2696: and p1.ledger_id = ps.ledger_id)
2697: and ps.end_date
2698: <= (select p2.end_date
2699: from gl_period_statuses p2
2700: where p2.period_name = b.last_valid_period_name
2701: and p2.application_id = ps.application_id
2702: and p2.ledger_id = ps.ledger_id))
2703: and bp.packet_id = g_packet_id_ursvd

Line 2858: gl_period_statuses ps,

2854: bo.funding_budget_version_id)
2855: from gl_budget_assignments ba,
2856: gl_budgets b,
2857: gl_budget_versions bv,
2858: gl_period_statuses ps,
2859: gl_bc_packets pk,
2860: gl_budorg_bc_options bo
2861: where
2862: ba.ledger_id(+) = g_ledger_id

Line 2879: from gl_period_statuses p1

2875: and ps.application_id = 101
2876: and ps.ledger_id = g_ledger_id
2877: and ps.period_name = pk.period_name
2878: and ps.start_date >= (select p1.start_date
2879: from gl_period_statuses p1
2880: where p1.period_name = b.first_valid_period_name
2881: and p1.application_id = ps.application_id
2882: and p1.ledger_id = ps.ledger_id)
2883: and ps.end_date <= (select p2.end_date

Line 2884: from gl_period_statuses p2

2880: where p1.period_name = b.first_valid_period_name
2881: and p1.application_id = ps.application_id
2882: and p1.ledger_id = ps.ledger_id)
2883: and ps.end_date <= (select p2.end_date
2884: from gl_period_statuses p2
2885: where p2.period_name = b.last_valid_period_name
2886: and p2.application_id = ps.application_id
2887: and p2.ledger_id = ps.ledger_id)
2888: and pk.rowid = bp.rowid

Line 3002: gl_period_statuses ps,

2998: null)))))))))))
2999: from gl_ussgl_transaction_codes uc,
3000: gl_budget_versions bv,
3001: gl_budget_period_ranges br,
3002: gl_period_statuses ps,
3003: gl_code_combinations cc,
3004: psa_option_details_gt od,
3005: gl_bc_packets pk
3006: where uc.chart_of_accounts_id (+) = g_coa_id

Line 3215: gl_period_statuses ps,

3211: min(bp.session_id),
3212: min(bp.serial_id),
3213: min(bp.application_id)
3214: from psa_option_details_gt od,
3215: gl_period_statuses ps,
3216: gl_summary_templates st,
3217: gl_account_hierarchies ah,
3218: gl_bc_packets bp,
3219: gl_summary_bc_options sb,

Line 3222: gl_period_statuses ps2

3218: gl_bc_packets bp,
3219: gl_summary_bc_options sb,
3220: gl_budgets b,
3221: gl_budget_versions bv,
3222: gl_period_statuses ps2
3223: where st.status = 'F'
3224: and sb.funds_check_level_code || od.funds_check_level_code <> 'DN'
3225: and st.template_id = ah.template_id
3226: and sb.funding_budget_version_id = decode(bp.actual_flag,

Line 3245: from GL_PERIOD_STATUSES P1

3241: and ps2.ledger_id = g_ledger_id
3242: and ps2.application_id = 101
3243: AND PS2.period_name = BP.period_name
3244: AND PS2.start_date >= (select P1.start_date
3245: from GL_PERIOD_STATUSES P1
3246: where P1.application_id = ps2.application_id
3247: and P1.ledger_id = ps2.ledger_id
3248: and P1.period_name = B.first_valid_period_name)
3249: AND PS2.end_date <= (select P2.end_date

Line 3250: from GL_PERIOD_STATUSES P2

3246: where P1.application_id = ps2.application_id
3247: and P1.ledger_id = ps2.ledger_id
3248: and P1.period_name = B.first_valid_period_name)
3249: AND PS2.end_date <= (select P2.end_date
3250: from GL_PERIOD_STATUSES P2
3251: where P2.application_id = ps2.application_id
3252: and P2.ledger_id = ps2.ledger_id
3253: and P2.period_name = B.last_valid_period_name)
3254: and ah.ledger_id = g_ledger_id

Line 3416: l_effective_period_num gl_period_statuses.effective_period_num%TYPE;

3412: --Bug 6823089 ..
3413: --l_max_packet_id gl_bc_packets.packet_id%type;
3414:
3415: -- Bug 5644702
3416: l_effective_period_num gl_period_statuses.effective_period_num%TYPE;
3417: l_period_name gl_period_statuses.period_name%TYPE;
3418: l_quarter_num gl_period_statuses.quarter_num%TYPE;
3419: l_period_year gl_period_statuses.period_year%TYPE;
3420:

Line 3417: l_period_name gl_period_statuses.period_name%TYPE;

3413: --l_max_packet_id gl_bc_packets.packet_id%type;
3414:
3415: -- Bug 5644702
3416: l_effective_period_num gl_period_statuses.effective_period_num%TYPE;
3417: l_period_name gl_period_statuses.period_name%TYPE;
3418: l_quarter_num gl_period_statuses.quarter_num%TYPE;
3419: l_period_year gl_period_statuses.period_year%TYPE;
3420:
3421: -- ========================= FND LOG ===========================

Line 3418: l_quarter_num gl_period_statuses.quarter_num%TYPE;

3414:
3415: -- Bug 5644702
3416: l_effective_period_num gl_period_statuses.effective_period_num%TYPE;
3417: l_period_name gl_period_statuses.period_name%TYPE;
3418: l_quarter_num gl_period_statuses.quarter_num%TYPE;
3419: l_period_year gl_period_statuses.period_year%TYPE;
3420:
3421: -- ========================= FND LOG ===========================
3422: l_full_path VARCHAR2(100);

Line 3419: l_period_year gl_period_statuses.period_year%TYPE;

3415: -- Bug 5644702
3416: l_effective_period_num gl_period_statuses.effective_period_num%TYPE;
3417: l_period_name gl_period_statuses.period_name%TYPE;
3418: l_quarter_num gl_period_statuses.quarter_num%TYPE;
3419: l_period_year gl_period_statuses.period_year%TYPE;
3420:
3421: -- ========================= FND LOG ===========================
3422: l_full_path VARCHAR2(100);
3423: -- ========================= FND LOG ===========================

Line 3522: -- gl_period_statuses to get the last period in the latest open year of

3518: -- with Funds Check Level None, and all Advisory Transactions with a
3519: -- lower rowid than that of the row currently being processed
3520:
3521: -- Subquery needs to join to gl_budgets, gl_budget_versions and
3522: -- gl_period_statuses to get the last period in the latest open year of
3523: -- the Funding Budget for the Boundary Code 'project'
3524:
3525: -- Summary of WHERE clauses based on Amount Type and Boundary :
3526: --

Line 3594: from gl_period_statuses ps,

3590: 'PE', nvl(pk.accounted_dr, 0) - nvl(pk.accounted_cr, 0),
3591: 'CE', nvl(pk.accounted_dr, 0) - nvl(pk.accounted_cr, 0),
3592: 0)
3593: )
3594: from gl_period_statuses ps,
3595: gl_budgets bd,
3596: gl_budget_versions bv,
3597: gl_bc_packets pk,
3598: gl_bc_packet_arrival_order ao

Line 3726: FROM gl_period_statuses

3722:
3723: BEGIN
3724: SELECT nvl(effective_period_num,0), period_name, NVL(quarter_num,0), NVL(period_year,0)
3725: INTO l_effective_period_num, l_period_name, l_quarter_num, l_period_year
3726: FROM gl_period_statuses
3727: WHERE ledger_id = g_ledger_id
3728: AND application_id = 101
3729: AND closing_status = 'O'
3730: AND effective_period_num =

Line 3732: FROM gl_period_statuses

3728: AND application_id = 101
3729: AND closing_status = 'O'
3730: AND effective_period_num =
3731: (SELECT max(effective_period_num)
3732: FROM gl_period_statuses
3733: WHERE ledger_id = g_ledger_id
3734: AND application_id = 101
3735: AND closing_status = 'O');
3736: EXCEPTION

Line 3803: period_year y, ledger_id s, application_id a from gl_period_statuses

3799: gl_balances gb
3800: -- ## selecting the latest open period
3801: -- ## Changes made For fix in Bug 3243216
3802: /* (select effective_period_num e, period_name n,quarter_num q,
3803: period_year y, ledger_id s, application_id a from gl_period_statuses
3804: where
3805: ledger_id= g_ledger_id and application_id =101 and closing_status='O'
3806: and effective_period_num =
3807: (select max(effective_period_num) from

Line 3808: gl_period_statuses where ledger_id= g_ledger_id and application_id =101 and

3804: where
3805: ledger_id= g_ledger_id and application_id =101 and closing_status='O'
3806: and effective_period_num =
3807: (select max(effective_period_num) from
3808: gl_period_statuses where ledger_id= g_ledger_id and application_id =101 and
3809: closing_status='O'))X*/ --Bug 5644702
3810: WHERE
3811: --- X.s = gb.ledger_id and x.a =101 and
3812: -- ## changes for the bug 3243216

Line 5584: from gl_period_statuses ps,

5580: ' ',
5581: 'Y',
5582: BP.ussgl_link_to_parent_id,
5583: 'glxfje() generated: ' || g_packet_id
5584: from gl_period_statuses ps,
5585: gl_je_headers jh,
5586: gl_bc_packets bp
5587: where ps.application_id = 101
5588: and ps.ledger_id = g_ledger_id

Line 5684: GL_PERIOD_STATUSES PS,

5680: decode(JL1.context,JL1.context3,null,JL1.attribute8),
5681: decode(JL1.context,JL1.context3,null,JL1.attribute9),
5682: decode(JL1.context,JL1.context3,null,JL1.attribute10)
5683: FROM
5684: GL_PERIOD_STATUSES PS,
5685: GL_JE_LINES JL,
5686: GL_JE_LINES JL1,
5687: GL_BC_PACKETS BP
5688: WHERE

Line 5929: from gl_period_statuses ps,

5925: l_approval_status_code,
5926: min(jb.chart_of_accounts_id),
5927: min(jb.period_set_name),
5928: min(jb.accounted_period_type)
5929: from gl_period_statuses ps,
5930: gl_bc_packets bp,
5931: gl_je_batches jb
5932: where ps.application_id = 101
5933: and ps.ledger_id = g_ledger_id

Line 8079: l_tmp_stmt := l_tmp_stmt || ' gl_period_statuses ps WHERE ps.application_id = '||l_appl_id||

8075: IF (l_actual_flag = 'B') THEN
8076: l_tmp_stmt := l_tmp_stmt || 'gl_budget_versions bv, ';
8077: END IF;
8078:
8079: l_tmp_stmt := l_tmp_stmt || ' gl_period_statuses ps WHERE ps.application_id = '||l_appl_id||
8080: ' AND ps.ledger_id = '||l_ledger_id ||
8081: ' AND ps.period_name = '||''''||l_period_name||''''||' AND h.je_batch_id = '||l_je_batch_id ||
8082: ' AND l.je_header_id = h.je_header_id';
8083:

Line 8789: GL_PERIOD_STATUSES PS

8785: GL_SUMMARY_TEMPLATES ST,
8786: GL_SUMMARY_BC_OPTIONS SB,
8787: GL_BUDGETS B,
8788: GL_BUDGET_VERSIONS BV,
8789: GL_PERIOD_STATUSES PS
8790:
8791: WHERE
8792: AH.ledger_id = p_ledger_id
8793: AND AH.detail_code_combination_id = BP.code_combination_id

Line 8812: FROM GL_PERIOD_STATUSES P1

8808: AND PS.application_id = 101
8809: AND PS.ledger_id = p_ledger_id
8810: AND PS.period_name = BP.period_name
8811: AND PS.effective_period_num >= (SELECT P1.effective_period_num
8812: FROM GL_PERIOD_STATUSES P1
8813: WHERE P1.period_name = B.first_valid_period_name
8814: AND P1.application_id = 101
8815: AND P1.ledger_id = p_ledger_id)
8816: AND PS.effective_period_num <= (SELECT P2.effective_period_num

Line 8817: FROM GL_PERIOD_STATUSES P2

8813: WHERE P1.period_name = B.first_valid_period_name
8814: AND P1.application_id = 101
8815: AND P1.ledger_id = p_ledger_id)
8816: AND PS.effective_period_num <= (SELECT P2.effective_period_num
8817: FROM GL_PERIOD_STATUSES P2
8818: WHERE P2.period_name = B.last_valid_period_name
8819: AND P2.application_id = 101
8820: AND P2.ledger_id = p_ledger_id)
8821: GROUP BY

Line 8938: GL_PERIOD_STATUSES PS

8934: GL_SUMMARY_TEMPLATES ST,
8935: GL_SUMMARY_BC_OPTIONS SB,
8936: GL_BUDGETS B,
8937: GL_BUDGET_VERSIONS BV,
8938: GL_PERIOD_STATUSES PS
8939: WHERE AH.ledger_id = p_ledger_id
8940: AND AH.detail_code_combination_id = BP.code_combination_id
8941: AND AH.template_id = p_curr_temp_id
8942: AND BP.status_code = 'A'

Line 8975: From GL_PERIOD_STATUSES P1

8971: AND PS.ledger_id = p_ledger_id
8972: AND PS.period_name = BP.period_name
8973: AND PS.effective_period_num >=
8974: ( Select P1.effective_period_num
8975: From GL_PERIOD_STATUSES P1
8976: Where P1.period_name = B.first_valid_period_name
8977: And P1.application_id = 101
8978: And P1.ledger_id = p_ledger_id)
8979: AND PS.effective_period_num <=

Line 8981: From GL_PERIOD_STATUSES P2

8977: And P1.application_id = 101
8978: And P1.ledger_id = p_ledger_id)
8979: AND PS.effective_period_num <=
8980: ( Select P2.effective_period_num
8981: From GL_PERIOD_STATUSES P2
8982: Where P2.period_name = B.last_valid_period_name
8983: And P2.application_id = 101
8984: And P2.ledger_id = p_ledger_id)
8985: GROUP BY

Line 9053: gl_period_statuses ps

9049: gl_summary_templates st,
9050: gl_summary_bc_options sb,
9051: gl_budgets b,
9052: gl_budget_versions bv,
9053: gl_period_statuses ps
9054: WHERE ah.ledger_id = p_ledger_id
9055: AND ah.template_id = p_curr_temp_id
9056: AND ah.summary_code_combination_id = bp2.code_combination_id
9057: AND st.template_id = p_curr_temp_id

Line 9079: FROM gl_period_statuses p1

9075: AND ps.ledger_id = p_ledger_id
9076: AND ps.period_name = bp.period_name
9077: AND ps.effective_period_num >=
9078: (SELECT p1.effective_period_num
9079: FROM gl_period_statuses p1
9080: WHERE p1.period_name = b.first_valid_period_name
9081: AND p1.application_id = 101
9082: AND p1.ledger_id = p_ledger_id)
9083: AND ps.effective_period_num <=

Line 9085: FROM gl_period_statuses p2

9081: AND p1.application_id = 101
9082: AND p1.ledger_id = p_ledger_id)
9083: AND ps.effective_period_num <=
9084: (SELECT p2.effective_period_num
9085: FROM gl_period_statuses p2
9086: WHERE p2.period_name = b.last_valid_period_name
9087: AND p2.application_id = 101
9088: AND p2.ledger_id = p_ledger_id)
9089: AND NVL (bp.budget_version_id, -1) =

Line 10229: gl_period_statuses ps

10225: xv.entity_id,
10226: NULL -- GROUP_ID
10227: BULK COLLECT INTO l_bc_pkts
10228: FROM xla_psa_bc_lines_v xv,
10229: gl_period_statuses ps
10230: WHERE ps.ledger_id = p_ledgerid and
10231: xv.period_name = ps.period_name and
10232: ps.application_id = 101 and
10233: -- Bug 4778812 start