APPS.PSA_FUNDS_CHECKER_PKG dependencies on PSA_OPTION_DETAILS_GT

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

1526:
1527: end if;
1528:
1529: -- =========================== FND LOG ===========================
1530: psa_utils.debug_other_string(g_state_level,l_full_path, ' Populating records in PSA_OPTION_DETAILS_GT ');
1531: -- ========================= FND LOG =============================
1532:
1533: FOR indx IN source_cat
1534: LOOP

Line 1554: INSERT INTO psa_option_details_gt

1550: -- =========================== FND LOG ===========================
1551: psa_utils.debug_other_string(g_state_level,l_full_path, ' l_option_selected -> '||l_option_selected);
1552: -- ========================= FND LOG =============================
1553:
1554: INSERT INTO psa_option_details_gt
1555: ( packet_id,
1556: je_source_name,
1557: je_category_name,
1558: gl_bc_option_source,

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

1588: 3, indx.je_category_name,
1589: 'Other');
1590:
1591: -- =========================== FND LOG ===========================
1592: psa_utils.debug_other_string(g_state_level,l_full_path, sql%rowcount||' Rows Inserted into psa_option_details_gt ');
1593: -- ========================= FND LOG =============================
1594:
1595:
1596: END LOOP;

Line 2664: from psa_option_details_gt od,

2660: bp.ussgl_link_to_parent_id,
2661: g_session_id,
2662: g_serial_id,
2663: g_resp_appl_id
2664: from psa_option_details_gt od,
2665: gl_budget_assignments ba,
2666: gl_bc_packets bp,
2667: gl_budorg_bc_options bo
2668: where (od.je_source_name || ';' || od.je_category_name =

Line 3004: psa_option_details_gt od,

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

Line 3040: psa_option_details_gt od,

3036: nvl(bo.funds_check_level_code, 'N'))), 'N'),
3037: min(bo.amount_type),
3038: min(bo.boundary_code)
3039: from gl_bc_packets pk,
3040: psa_option_details_gt od,
3041: gl_budget_assignments ba,
3042: gl_budorg_bc_options bo
3043: where pk.rowid = bp.rowid
3044: and (od.je_source_name || ';' || od.je_category_name =

Line 3214: from psa_option_details_gt od,

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