DBA Data[Home] [Help]

APPS.PSP_PREGEN dependencies on PSP_ORGANIZATION_ACCOUNTS

Line 806: psp_organization_accounts susp --- introduced for 5164744

802: a.suspense_auto_glccid,
803: a.suspense_auto_exp_type
804: FROM psp_distribution_interface a,
805: per_time_periods T,
806: psp_organization_accounts susp --- introduced for 5164744
807: WHERE batch_name = p_batch_name and
808: T.time_period_id = a.time_period_id and
809: susp.organization_account_id(+) = a.suspense_org_account_id;
810: if sql%NOTFOUND then

Line 2455: FROM psp_organization_accounts

2451: task_id,
2452: award_id,
2453: expenditure_type,
2454: expenditure_organization_id
2455: FROM psp_organization_accounts
2456: WHERE business_group_id = p_business_group_id
2457: AND set_of_books_id = p_set_of_books_id
2458: AND organization_id = p_organization_id
2459: AND account_type_code = p_account_type_code

Line 2470: FROM psp_organization_accounts

2466: task_id,
2467: award_id,
2468: expenditure_type,
2469: expenditure_organization_id
2470: FROM psp_organization_accounts
2471: WHERE organization_account_id = p_suspense_account_id;
2472:
2473: /* Following cursor is added for bug 2514611 */
2474: CURSOR employee_name_cur IS