APPS.PSP_ENC_CREATE_LINES dependencies on PSP_ELEMENT_TYPE_ACCOUNTS

Line 3890: FROM psp_element_type_accounts

3886: CURSOR global_element_cur IS
3887: SELECT GREATEST(l_min_start_date, start_date_active) start_date_active,
3888: LEAST(l_max_end_date, end_date_active) end_date_active,
3889: SUM(percent) schedule_percent
3890: FROM psp_element_type_accounts
3891: WHERE business_group_id = p_business_group_id
3892: AND set_of_books_id = p_set_of_books_id
3893: AND element_type_id = p_element_type_id
3894: AND ( gl_code_combination_id IS NOT NULL

Line 9730: FROM psp_element_type_accounts peta

9726: DECODE(g_dff_grouping_option, 'Y', peta.attribute8, NULL),
9727: DECODE(g_dff_grouping_option, 'Y', peta.attribute9, NULL),
9728: DECODE(g_dff_grouping_option, 'Y', peta.attribute10, NULL),
9729: DECODE(peta.expenditure_type, NULL, 'N', 'E') acct_type
9730: FROM psp_element_type_accounts peta
9731: WHERE peta.element_type_id = p_element_type_id
9732: AND peta.business_group_id = p_business_group_id
9733: AND peta.set_of_books_id = p_set_of_books_id
9734: AND ( peta.gl_code_combination_id IS NOT NULL