[Home] [Help]
2448: AND id_flex_num = l_chart_of_accounts_id;
2449:
2450: Cursor C_ld_payroll is
2451: select 'exists'
2452: from psb_ld_payroll_maps
2453: where data_extract_id = p_data_extract_id;
2454:
2455: Cursor C_psp is
2456: Select nvl(effective_start_date,p_date) effective_start_date
2453: where data_extract_id = p_data_extract_id;
2454:
2455: Cursor C_psp is
2456: Select nvl(effective_start_date,p_date) effective_start_date
2457: from psb_ld_payroll_maps plp
2458: where plp.payroll_id = le_payroll_id
2459: and plp.data_extract_id = p_data_extract_id;
2460:
2461: l_proportion NUMBER;