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 286: /* GL_PERIOD_STATUSES */

282: /* GL_BC_PERIOD_MAP */
283: /* GL_BC_DUAL */
284: /* GL_BC_DUAL2 */
285: /* GL_CONCURRENCY_CONTROL */
286: /* GL_PERIOD_STATUSES */
287: /* GL_LOOKUPS */
288: /* GL_USSGL_TRANSACTION_CODES */
289: /* GL_USSGL_ACCOUNT_PAIRS */
290: /* GL_BALANCES */

Line 2689: gl_period_statuses ps

2685: and bo.range_id(+) = ba.range_id
2686: and bo.funding_budget_version_id
2687: in (select BV1.budget_version_id
2688: from gl_budget_versions bv1, gl_budgets b,
2689: gl_period_statuses ps
2690: where ba.ledger_id = g_ledger_id
2691: and ba.currency_code = bp.currency_code
2692: and ba.code_combination_id = bp.code_combination_id
2693: and b.budget_name = bv1.budget_name

Line 2704: from gl_period_statuses p1

2700: and ps.ledger_id = g_ledger_id
2701: and ps.period_name = bp.period_name
2702: and ps.start_date
2703: >= (select p1.start_date
2704: from gl_period_statuses p1
2705: where p1.period_name = b.first_valid_period_name
2706: and p1.application_id = ps.application_id
2707: and p1.ledger_id = ps.ledger_id)
2708: and ps.end_date

Line 2710: from gl_period_statuses p2

2706: and p1.application_id = ps.application_id
2707: and p1.ledger_id = ps.ledger_id)
2708: and ps.end_date
2709: <= (select p2.end_date
2710: from gl_period_statuses p2
2711: where p2.period_name = b.last_valid_period_name
2712: and p2.application_id = ps.application_id
2713: and p2.ledger_id = ps.ledger_id))
2714: and bp.packet_id = g_packet_id_ursvd

Line 2869: gl_period_statuses ps,

2865: bo.funding_budget_version_id)
2866: from gl_budget_assignments ba,
2867: gl_budgets b,
2868: gl_budget_versions bv,
2869: gl_period_statuses ps,
2870: gl_bc_packets pk,
2871: gl_budorg_bc_options bo
2872: where
2873: ba.ledger_id(+) = g_ledger_id

Line 2890: from gl_period_statuses p1

2886: and ps.application_id = 101
2887: and ps.ledger_id = g_ledger_id
2888: and ps.period_name = pk.period_name
2889: and ps.start_date >= (select p1.start_date
2890: from gl_period_statuses p1
2891: where p1.period_name = b.first_valid_period_name
2892: and p1.application_id = ps.application_id
2893: and p1.ledger_id = ps.ledger_id)
2894: and ps.end_date <= (select p2.end_date

Line 2895: from gl_period_statuses p2

2891: where p1.period_name = b.first_valid_period_name
2892: and p1.application_id = ps.application_id
2893: and p1.ledger_id = ps.ledger_id)
2894: and ps.end_date <= (select p2.end_date
2895: from gl_period_statuses p2
2896: where p2.period_name = b.last_valid_period_name
2897: and p2.application_id = ps.application_id
2898: and p2.ledger_id = ps.ledger_id)
2899: and pk.rowid = bp.rowid

Line 3015: gl_period_statuses ps,

3011: null)))))))))))))
3012: from gl_ussgl_transaction_codes uc,
3013: gl_budget_versions bv,
3014: gl_budget_period_ranges br,
3015: gl_period_statuses ps,
3016: gl_code_combinations cc,
3017: psa_option_details_gt od,
3018: gl_bc_packets pk
3019: where uc.chart_of_accounts_id (+) = g_coa_id

Line 3228: gl_period_statuses ps,

3224: min(bp.session_id),
3225: min(bp.serial_id),
3226: min(bp.application_id)
3227: from psa_option_details_gt od,
3228: gl_period_statuses ps,
3229: gl_summary_templates st,
3230: gl_account_hierarchies ah,
3231: gl_bc_packets bp,
3232: gl_summary_bc_options sb,

Line 3235: gl_period_statuses ps2

3231: gl_bc_packets bp,
3232: gl_summary_bc_options sb,
3233: gl_budgets b,
3234: gl_budget_versions bv,
3235: gl_period_statuses ps2
3236: where st.status = 'F'
3237: and sb.funds_check_level_code || od.funds_check_level_code <> 'DN'
3238: and st.template_id = ah.template_id
3239: and sb.funding_budget_version_id = decode(bp.actual_flag,

Line 3258: from GL_PERIOD_STATUSES P1

3254: and ps2.ledger_id = g_ledger_id
3255: and ps2.application_id = 101
3256: AND PS2.period_name = BP.period_name
3257: AND PS2.start_date >= (select P1.start_date
3258: from GL_PERIOD_STATUSES P1
3259: where P1.application_id = ps2.application_id
3260: and P1.ledger_id = ps2.ledger_id
3261: and P1.period_name = B.first_valid_period_name)
3262: AND PS2.end_date <= (select P2.end_date

Line 3263: from GL_PERIOD_STATUSES P2

3259: where P1.application_id = ps2.application_id
3260: and P1.ledger_id = ps2.ledger_id
3261: and P1.period_name = B.first_valid_period_name)
3262: AND PS2.end_date <= (select P2.end_date
3263: from GL_PERIOD_STATUSES P2
3264: where P2.application_id = ps2.application_id
3265: and P2.ledger_id = ps2.ledger_id
3266: and P2.period_name = B.last_valid_period_name)
3267: and ah.ledger_id = g_ledger_id

Line 3429: l_effective_period_num gl_period_statuses.effective_period_num%TYPE;

3425: --Bug 6823089 ..
3426: --l_max_packet_id gl_bc_packets.packet_id%type;
3427:
3428: -- Bug 5644702
3429: l_effective_period_num gl_period_statuses.effective_period_num%TYPE;
3430: l_period_name gl_period_statuses.period_name%TYPE;
3431: l_quarter_num gl_period_statuses.quarter_num%TYPE;
3432: l_period_year gl_period_statuses.period_year%TYPE;
3433:

Line 3430: l_period_name gl_period_statuses.period_name%TYPE;

3426: --l_max_packet_id gl_bc_packets.packet_id%type;
3427:
3428: -- Bug 5644702
3429: l_effective_period_num gl_period_statuses.effective_period_num%TYPE;
3430: l_period_name gl_period_statuses.period_name%TYPE;
3431: l_quarter_num gl_period_statuses.quarter_num%TYPE;
3432: l_period_year gl_period_statuses.period_year%TYPE;
3433:
3434: resource_busy exception;

Line 3431: l_quarter_num gl_period_statuses.quarter_num%TYPE;

3427:
3428: -- Bug 5644702
3429: l_effective_period_num gl_period_statuses.effective_period_num%TYPE;
3430: l_period_name gl_period_statuses.period_name%TYPE;
3431: l_quarter_num gl_period_statuses.quarter_num%TYPE;
3432: l_period_year gl_period_statuses.period_year%TYPE;
3433:
3434: resource_busy exception;
3435: l_psa_max_lock_wait_count fnd_profile_option_values.profile_option_value%TYPE :=0;

Line 3432: l_period_year gl_period_statuses.period_year%TYPE;

3428: -- Bug 5644702
3429: l_effective_period_num gl_period_statuses.effective_period_num%TYPE;
3430: l_period_name gl_period_statuses.period_name%TYPE;
3431: l_quarter_num gl_period_statuses.quarter_num%TYPE;
3432: l_period_year gl_period_statuses.period_year%TYPE;
3433:
3434: resource_busy exception;
3435: l_psa_max_lock_wait_count fnd_profile_option_values.profile_option_value%TYPE :=0;
3436: l_psa_lock_wait_interval fnd_profile_option_values.profile_option_value%TYPE :=0;

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

3592: -- with Funds Check Level None, and all Advisory Transactions with a
3593: -- lower rowid than that of the row currently being processed
3594:
3595: -- Subquery needs to join to gl_budgets, gl_budget_versions and
3596: -- gl_period_statuses to get the last period in the latest open year of
3597: -- the Funding Budget for the Boundary Code 'project'
3598:
3599: -- Summary of WHERE clauses based on Amount Type and Boundary :
3600: --

Line 3668: from gl_period_statuses ps,

3664: 'PE', nvl(pk.accounted_dr, 0) - nvl(pk.accounted_cr, 0),
3665: 'CE', nvl(pk.accounted_dr, 0) - nvl(pk.accounted_cr, 0),
3666: 0)
3667: )
3668: from gl_period_statuses ps,
3669: gl_budgets bd,
3670: gl_budget_versions bv,
3671: gl_bc_packets pk,
3672: gl_bc_packet_arrival_order ao

Line 3801: FROM gl_period_statuses

3797:
3798: BEGIN
3799: SELECT nvl(effective_period_num,0), period_name, NVL(quarter_num,0), NVL(period_year,0)
3800: INTO l_effective_period_num, l_period_name, l_quarter_num, l_period_year
3801: FROM gl_period_statuses
3802: WHERE ledger_id = g_ledger_id
3803: AND application_id = 101
3804: AND closing_status = 'O'
3805: AND effective_period_num =

Line 3807: FROM gl_period_statuses

3803: AND application_id = 101
3804: AND closing_status = 'O'
3805: AND effective_period_num =
3806: (SELECT max(effective_period_num)
3807: FROM gl_period_statuses
3808: WHERE ledger_id = g_ledger_id
3809: AND application_id = 101
3810: AND closing_status = 'O');
3811: EXCEPTION

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

3874: gl_balances gb
3875: -- ## selecting the latest open period
3876: -- ## Changes made For fix in Bug 3243216
3877: /* (select effective_period_num e, period_name n,quarter_num q,
3878: period_year y, ledger_id s, application_id a from gl_period_statuses
3879: where
3880: ledger_id= g_ledger_id and application_id =101 and closing_status='O'
3881: and effective_period_num =
3882: (select max(effective_period_num) from

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

3879: where
3880: ledger_id= g_ledger_id and application_id =101 and closing_status='O'
3881: and effective_period_num =
3882: (select max(effective_period_num) from
3883: gl_period_statuses where ledger_id= g_ledger_id and application_id =101 and
3884: closing_status='O'))X*/ --Bug 5644702
3885: WHERE
3886: --- X.s = gb.ledger_id and x.a =101 and
3887: -- ## changes for the bug 3243216

Line 5659: from gl_period_statuses ps,

5655: ' ',
5656: 'Y',
5657: BP.ussgl_link_to_parent_id,
5658: 'glxfje() generated: ' || g_packet_id
5659: from gl_period_statuses ps,
5660: gl_je_headers jh,
5661: gl_bc_packets bp
5662: where ps.application_id = 101
5663: and ps.ledger_id = g_ledger_id

Line 5759: GL_PERIOD_STATUSES PS,

5755: decode(JL1.context,JL1.context3,null,JL1.attribute8),
5756: decode(JL1.context,JL1.context3,null,JL1.attribute9),
5757: decode(JL1.context,JL1.context3,null,JL1.attribute10)
5758: FROM
5759: GL_PERIOD_STATUSES PS,
5760: GL_JE_LINES JL,
5761: GL_JE_LINES JL1,
5762: GL_BC_PACKETS BP
5763: WHERE

Line 6004: from gl_period_statuses ps,

6000: l_approval_status_code,
6001: min(jb.chart_of_accounts_id),
6002: min(jb.period_set_name),
6003: min(jb.accounted_period_type)
6004: from gl_period_statuses ps,
6005: gl_bc_packets bp,
6006: gl_je_batches jb
6007: where ps.application_id = 101
6008: and ps.ledger_id = g_ledger_id

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

8261: IF (l_actual_flag = 'B') THEN
8262: l_tmp_stmt := l_tmp_stmt || 'gl_budget_versions bv, ';
8263: END IF;
8264:
8265: l_tmp_stmt := l_tmp_stmt || ' gl_period_statuses ps WHERE ps.application_id = '||l_appl_id||
8266: ' AND ps.ledger_id = '||l_ledger_id ||
8267: ' AND ps.period_name = '||''''||l_period_name||''''||' AND h.je_batch_id = '||l_je_batch_id ||
8268: ' AND l.je_header_id = h.je_header_id';
8269:

Line 8975: GL_PERIOD_STATUSES PS

8971: GL_SUMMARY_TEMPLATES ST,
8972: GL_SUMMARY_BC_OPTIONS SB,
8973: GL_BUDGETS B,
8974: GL_BUDGET_VERSIONS BV,
8975: GL_PERIOD_STATUSES PS
8976:
8977: WHERE
8978: AH.ledger_id = p_ledger_id
8979: AND AH.detail_code_combination_id = BP.code_combination_id

Line 8998: FROM GL_PERIOD_STATUSES P1

8994: AND PS.application_id = 101
8995: AND PS.ledger_id = p_ledger_id
8996: AND PS.period_name = BP.period_name
8997: AND PS.effective_period_num >= (SELECT P1.effective_period_num
8998: FROM GL_PERIOD_STATUSES P1
8999: WHERE P1.period_name = B.first_valid_period_name
9000: AND P1.application_id = 101
9001: AND P1.ledger_id = p_ledger_id)
9002: AND PS.effective_period_num <= (SELECT P2.effective_period_num

Line 9003: FROM GL_PERIOD_STATUSES P2

8999: WHERE P1.period_name = B.first_valid_period_name
9000: AND P1.application_id = 101
9001: AND P1.ledger_id = p_ledger_id)
9002: AND PS.effective_period_num <= (SELECT P2.effective_period_num
9003: FROM GL_PERIOD_STATUSES P2
9004: WHERE P2.period_name = B.last_valid_period_name
9005: AND P2.application_id = 101
9006: AND P2.ledger_id = p_ledger_id)
9007: GROUP BY

Line 9124: GL_PERIOD_STATUSES PS

9120: GL_SUMMARY_TEMPLATES ST,
9121: GL_SUMMARY_BC_OPTIONS SB,
9122: GL_BUDGETS B,
9123: GL_BUDGET_VERSIONS BV,
9124: GL_PERIOD_STATUSES PS
9125: WHERE AH.ledger_id = p_ledger_id
9126: AND AH.detail_code_combination_id = BP.code_combination_id
9127: AND AH.template_id = p_curr_temp_id
9128: AND BP.status_code = 'A'

Line 9161: From GL_PERIOD_STATUSES P1

9157: AND PS.ledger_id = p_ledger_id
9158: AND PS.period_name = BP.period_name
9159: AND PS.effective_period_num >=
9160: ( Select P1.effective_period_num
9161: From GL_PERIOD_STATUSES P1
9162: Where P1.period_name = B.first_valid_period_name
9163: And P1.application_id = 101
9164: And P1.ledger_id = p_ledger_id)
9165: AND PS.effective_period_num <=

Line 9167: From GL_PERIOD_STATUSES P2

9163: And P1.application_id = 101
9164: And P1.ledger_id = p_ledger_id)
9165: AND PS.effective_period_num <=
9166: ( Select P2.effective_period_num
9167: From GL_PERIOD_STATUSES P2
9168: Where P2.period_name = B.last_valid_period_name
9169: And P2.application_id = 101
9170: And P2.ledger_id = p_ledger_id)
9171: GROUP BY

Line 9239: gl_period_statuses ps

9235: gl_summary_templates st,
9236: gl_summary_bc_options sb,
9237: gl_budgets b,
9238: gl_budget_versions bv,
9239: gl_period_statuses ps
9240: WHERE ah.ledger_id = p_ledger_id
9241: AND ah.template_id = p_curr_temp_id
9242: AND ah.summary_code_combination_id = bp2.code_combination_id
9243: AND st.template_id = p_curr_temp_id

Line 9265: FROM gl_period_statuses p1

9261: AND ps.ledger_id = p_ledger_id
9262: AND ps.period_name = bp.period_name
9263: AND ps.effective_period_num >=
9264: (SELECT p1.effective_period_num
9265: FROM gl_period_statuses p1
9266: WHERE p1.period_name = b.first_valid_period_name
9267: AND p1.application_id = 101
9268: AND p1.ledger_id = p_ledger_id)
9269: AND ps.effective_period_num <=

Line 9271: FROM gl_period_statuses p2

9267: AND p1.application_id = 101
9268: AND p1.ledger_id = p_ledger_id)
9269: AND ps.effective_period_num <=
9270: (SELECT p2.effective_period_num
9271: FROM gl_period_statuses p2
9272: WHERE p2.period_name = b.last_valid_period_name
9273: AND p2.application_id = 101
9274: AND p2.ledger_id = p_ledger_id)
9275: AND NVL (bp.budget_version_id, -1) =

Line 10529: gl_period_statuses ps

10525: xv.entity_id,
10526: NULL -- GROUP_ID
10527: BULK COLLECT INTO l_bc_pkts
10528: FROM xla_psa_bc_lines_v xv,
10529: gl_period_statuses ps
10530: WHERE ps.ledger_id = p_ledgerid and
10531: xv.period_name = ps.period_name and
10532: ps.application_id = 101 and
10533: -- Bug 4778812 start