DBA Data[Home] [Help]

APPS.PSP_PREGEN dependencies on PSP_ORGANIZATION_ACCOUNTS

Line 809: psp_organization_accounts susp --- introduced for 5164744

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

Line 2458: FROM psp_organization_accounts

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

Line 2473: FROM psp_organization_accounts

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