APPS.PSA_FUNDS_CHECKER_PKG dependencies on PSA_OPTION_DETAILS_GT

Line 1541: psa_utils.debug_other_string(g_state_level,l_full_path, ' Populating records in PSA_OPTION_DETAILS_GT ');

1537:
1538: end if;
1539:
1540: -- =========================== FND LOG ===========================
1541: psa_utils.debug_other_string(g_state_level,l_full_path, ' Populating records in PSA_OPTION_DETAILS_GT ');
1542: -- ========================= FND LOG =============================
1543:
1544: FOR indx IN source_cat
1545: LOOP

Line 1565: INSERT INTO psa_option_details_gt

1561: -- =========================== FND LOG ===========================
1562: psa_utils.debug_other_string(g_state_level,l_full_path, ' l_option_selected -> '||l_option_selected);
1563: -- ========================= FND LOG =============================
1564:
1565: INSERT INTO psa_option_details_gt
1566: ( packet_id,
1567: je_source_name,
1568: je_category_name,
1569: gl_bc_option_source,

Line 1603: psa_utils.debug_other_string(g_state_level,l_full_path, sql%rowcount||' Rows Inserted into psa_option_details_gt ');

1599: 3, indx.je_category_name,
1600: 'Other');
1601:
1602: -- =========================== FND LOG ===========================
1603: psa_utils.debug_other_string(g_state_level,l_full_path, sql%rowcount||' Rows Inserted into psa_option_details_gt ');
1604: -- ========================= FND LOG =============================
1605:
1606:
1607: END LOOP;

Line 2675: from psa_option_details_gt od,

2671: bp.ussgl_link_to_parent_id,
2672: g_session_id,
2673: g_serial_id,
2674: g_resp_appl_id
2675: from psa_option_details_gt od,
2676: gl_budget_assignments ba,
2677: gl_bc_packets bp,
2678: gl_budorg_bc_options bo
2679: where (od.je_source_name || ';' || od.je_category_name =

Line 3017: psa_option_details_gt od,

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
3020: and uc.ussgl_transaction_code (+) =
3021: nvl(pk.ussgl_transaction_code, -1)

Line 3053: psa_option_details_gt od,

3049: nvl(bo.funds_check_level_code, 'N'))), 'N'),
3050: min(bo.amount_type),
3051: min(bo.boundary_code)
3052: from gl_bc_packets pk,
3053: psa_option_details_gt od,
3054: gl_budget_assignments ba,
3055: gl_budorg_bc_options bo
3056: where pk.rowid = bp.rowid
3057: and (od.je_source_name || ';' || od.je_category_name =

Line 3227: from psa_option_details_gt od,

3223: 'n/a', 'I'),
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,