DBA Data[Home] [Help]

APPS.PSP_ENC_CREATE_LINES dependencies on PSP_ELEMENT_TYPE_ACCOUNTS

Line 4125: FROM psp_element_type_accounts

4121: CURSOR global_element_cur IS
4122: SELECT GREATEST(l_min_start_date, start_date_active) start_date_active,
4123: LEAST(l_max_end_date, end_date_active) end_date_active,
4124: SUM(percent) schedule_percent
4125: FROM psp_element_type_accounts
4126: WHERE business_group_id = p_business_group_id
4127: AND set_of_books_id = p_set_of_books_id
4128: AND element_type_id = p_element_type_id
4129: AND ( gl_code_combination_id IS NOT NULL

Line 10360: FROM psp_element_type_accounts peta

10356: DECODE(g_dff_grouping_option, 'Y', peta.attribute8, NULL),
10357: DECODE(g_dff_grouping_option, 'Y', peta.attribute9, NULL),
10358: DECODE(g_dff_grouping_option, 'Y', peta.attribute10, NULL),
10359: DECODE(peta.expenditure_type, NULL, 'N', 'E') acct_type
10360: FROM psp_element_type_accounts peta
10361: WHERE peta.element_type_id = p_element_type_id
10362: AND peta.business_group_id = p_business_group_id
10363: AND peta.set_of_books_id = p_set_of_books_id
10364: AND ( peta.gl_code_combination_id IS NOT NULL