[Home] [Help]
1023:
1024: l_return_status VARCHAR2(1);
1025:
1026: /* Bug No 2782604 Start */
1027: -- changed the query from table 'psb_position_pay_distributions' to
1028: -- view 'psb_positions_pay_distrs_v'
1029: -- commented the worksheet_id filter the query since it is already present in the view
1030: cursor c_WSDist is
1031: select code_combination_id,
1031: select code_combination_id,
1032: distribution_percent,
1033: effective_start_date,
1034: effective_end_date
1035: from PSB_POSITION_PAY_DISTRIBUTIONS a
1036: where position_id = p_position_id
1037: and chart_of_accounts_id = p_flex_code
1038: and code_combination_id is not null
1039: and ((worksheet_id = p_worksheet_id) or (worksheet_id is null
1038: and code_combination_id is not null
1039: and ((worksheet_id = p_worksheet_id) or (worksheet_id is null
1040: and not exists
1041: (select 1
1042: from psb_position_pay_distributions c
1043: where (
1044: ( nvl(c.effective_start_date, p_end_date + 1)
1045: between nvl(a.effective_start_date, p_end_date)
1046: and nvl(a.effective_end_date, nvl(p_end_date, c.effective_start_date)))
1074: select code_combination_id,
1075: distribution_percent,
1076: effective_start_date,
1077: effective_end_date
1078: from PSB_POSITION_PAY_DISTRIBUTIONS a
1079: where code_combination_id is not null
1080: /* Bug No 2747205 Start */
1081: and chart_of_accounts_id = p_flex_code
1082: and (worksheet_id is null
1081: and chart_of_accounts_id = p_flex_code
1082: and (worksheet_id is null
1083: and not exists
1084: (select 1
1085: from psb_position_pay_distributions c
1086: where (
1087: ( nvl(c.effective_start_date, p_end_date + 1)
1088: between nvl(a.effective_start_date, p_end_date)
1089: and nvl(a.effective_end_date, nvl(p_end_date, c.effective_start_date)))