DBA Data[Home] [Help]

APPS.PSP_ENC_CREATE_LINES dependencies on PSP_ORGANIZATION_ACCOUNTS

Line 8602: PSP_ORGANIZATION_ACCOUNTS pos,

8598: DECODE(g_dff_grouping_option, 'Y', pel.attribute9, NULL) attribute9,
8599: DECODE(g_dff_grouping_option, 'Y', pel.attribute10, NULL) attribute10,
8600: pa.org_id
8601: FROM PSP_ENC_LINES pel,
8602: PSP_ORGANIZATION_ACCOUNTS pos,
8603: pa_projects_all pa
8604: WHERE pel.ENCUMBRANCE_AMOUNT <> 0
8605: AND pel.assignment_id = p_assignment_id
8606: AND pel.payroll_id = p_payroll_id

Line 10583: FROM psp_organization_accounts poa

10579: DECODE(g_dff_grouping_option, 'Y', poa.attribute8, NULL),
10580: DECODE(g_dff_grouping_option, 'Y', poa.attribute9, NULL),
10581: DECODE(g_dff_grouping_option, 'Y', poa.attribute10, NULL),
10582: DECODE(poa.expenditure_type, NULL, 'N', 'E') acct_type
10583: FROM psp_organization_accounts poa
10584: WHERE poa.organization_id = p_organization_id
10585: AND poa.business_group_id = p_business_group_id
10586: AND poa.set_of_books_id = p_set_of_books_id
10587: AND poa.account_type_code = 'D'

Line 10622: FROM psp_organization_accounts poa

10618: DECODE(g_dff_grouping_option, 'Y', poa.attribute8, NULL),
10619: DECODE(g_dff_grouping_option, 'Y', poa.attribute9, NULL),
10620: DECODE(g_dff_grouping_option, 'Y', poa.attribute10, NULL),
10621: DECODE(poa.expenditure_type, NULL, 'N', 'E') acct_type
10622: FROM psp_organization_accounts poa
10623: WHERE poa.organization_id = p_organization_id
10624: AND poa.business_group_id = p_business_group_id
10625: AND poa.set_of_books_id = p_set_of_books_id
10626: AND poa.account_type_code = 'S'

Line 10659: FROM psp_organization_accounts poa

10655: DECODE(g_dff_grouping_option, 'Y', poa.attribute8, NULL),
10656: DECODE(g_dff_grouping_option, 'Y', poa.attribute9, NULL),
10657: DECODE(g_dff_grouping_option, 'Y', poa.attribute10, NULL),
10658: DECODE(poa.expenditure_type, NULL, 'N', 'E') acct_type
10659: FROM psp_organization_accounts poa
10660: WHERE poa.business_group_id = p_business_group_id
10661: AND poa.set_of_books_id = p_set_of_books_id
10662: AND poa.account_type_code = 'G'
10663: AND poa.start_date_active <= g_enc_org_end_date