APPS.PSB_WS_POS3 dependencies on PSB_PAY_ELEMENT_RATES

Line 939: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates

935: end;
936: else
937: begin
938:
939: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates
940: (p_api_version => 1.0,
941: p_return_status => l_return_status,
942: p_msg_count => l_msg_count,
943: p_msg_data => l_msg_data,

Line 1031: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates

1027: for c_ElemOption_Rec in c_ElemOption loop
1028:
1029: l_option_flag := 'Y';
1030:
1031: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates
1032: (p_api_version => 1.0,
1033: p_return_status => l_return_status,
1034: p_msg_count => l_msg_count,
1035: p_msg_data => l_msg_data,

Line 1057: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates

1053:
1054: end loop;
1055:
1056: if (l_option_flag = 'N') then
1057: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates
1058: (p_api_version => 1.0,
1059: p_return_status => l_return_status,
1060: p_msg_count => l_msg_count,
1061: p_msg_data => l_msg_data,

Line 1139: from PSB_PAY_ELEMENT_RATES

1135: element_value_type,
1136: element_value,
1137: formula_id,
1138: pay_basis
1139: from PSB_PAY_ELEMENT_RATES
1140: where worksheet_id is null
1141: and currency_code = p_currency_code
1142: and ((p_pay_element_option_id is null)
1143: or (pay_element_option_id = p_pay_element_option_id))

Line 1191: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates

1187: end if;
1188:
1189: l_element_value_type := c_ElemRates_Rec.element_value_type;
1190:
1191: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates
1192: (p_api_version => 1.0,
1193: p_return_status => l_return_status,
1194: p_msg_count => l_msg_count,
1195: p_msg_data => l_msg_data,

Line 1290: from PSB_PAY_ELEMENT_RATES a,

1286: a.pay_basis,
1287: a.maximum_value,
1288: a.mid_value,
1289: a.minimum_value
1290: from PSB_PAY_ELEMENT_RATES a,
1291: PSB_PAY_ELEMENTS b
1292: where a.worksheet_id is null
1293: and a.currency_code = p_currency_code
1294: and (((a.effective_start_date <= p_end_date)

Line 1326: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates

1322: l_maximum_value := c_ElemRates_Rec.maximum_value + l_increment_by * p_compound_factor;
1323: l_mid_value := c_ElemRates_Rec.mid_value + l_increment_by * p_compound_factor;
1324: l_minimum_value := c_ElemRates_Rec.minimum_value + l_increment_by * p_compound_factor;
1325:
1326: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates
1327: (p_api_version => 1.0,
1328: p_return_status => l_return_status,
1329: p_msg_count => l_msg_count,
1330: p_msg_data => l_msg_data,

Line 1383: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates

1379: l_minimum_value
1380: := c_ElemRates_Rec.minimum_value * POWER(1 + l_increment_by / 100, p_compound_factor);
1381: /* Bug 2820755 End */
1382:
1383: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates
1384: (p_api_version => 1.0,
1385: p_return_status => l_return_status,
1386: p_msg_count => l_msg_count,
1387: p_msg_data => l_msg_data,

Line 2698: from PSB_PAY_ELEMENT_RATES

2694: element_value_type,
2695: element_value,
2696: formula_id,
2697: pay_basis
2698: from PSB_PAY_ELEMENT_RATES
2699: where worksheet_id is null
2700: and ((p_pay_element_option_id is null) or (pay_element_option_id = p_pay_element_option_id))
2701: and (((effective_start_date <= EndDate)
2702: and (effective_end_date is null))

Line 3270: from PSB_PAY_ELEMENT_RATES

3266: formula_id,
3267: pay_basis,
3268: effective_start_date,
3269: effective_end_date
3270: from PSB_PAY_ELEMENT_RATES
3271: where worksheet_id is null
3272: and ((ElemOptID is null) or (pay_element_option_id = ElemOptID))
3273: and (((EndDate is not null)
3274: and (((effective_start_date <= EndDate)