APPS.PSB_PAY_ELEMENTS_PVT dependencies on PSB_PAY_ELEMENT_RATES

Line 518: DELETE psb_pay_element_rates

514: -- Delete dependent detail records to maintain ISOLATED master-detail
515: -- form relation.
516: --
517:
518: DELETE psb_pay_element_rates
519: WHERE pay_element_id = l_pay_element_id ;
520:
521: DELETE psb_pay_element_options
522: WHERE pay_element_id = l_pay_element_id ;

Line 1149: FROM psb_pay_element_rates

1145: worksheet_id,element_value_type,
1146: element_value,formula_id,
1147: maximum_value,mid_value,
1148: minimum_value,currency_code,pay_basis
1149: FROM psb_pay_element_rates
1150: WHERE (((pay_element_option_id = l_source_pay_element_option_id ) AND
1151: (pay_element_id = p_source_pay_element_id)) or
1152: ((pay_element_id = p_source_pay_element_id) AND
1153: (pay_element_option_id IS NULL)))

Line 1353: SELECT psb_pay_element_rates_s.NEXTVAL

1349:
1350: For l_pay_element_rates_rec in l_pay_element_rates_csr
1351: Loop
1352:
1353: SELECT psb_pay_element_rates_s.NEXTVAL
1354: INTO l_pay_element_rate_id
1355: FROM DUAL;
1356:
1357: PSB_PAY_ELEMENT_RATES_PVT.INSERT_ROW

Line 1357: PSB_PAY_ELEMENT_RATES_PVT.INSERT_ROW

1353: SELECT psb_pay_element_rates_s.NEXTVAL
1354: INTO l_pay_element_rate_id
1355: FROM DUAL;
1356:
1357: PSB_PAY_ELEMENT_RATES_PVT.INSERT_ROW
1358: ( p_api_version => 1.0,
1359: p_init_msg_list => null,
1360: p_commit => null,
1361: p_validation_level => null,

Line 1405: SELECT psb_pay_element_rates_s.NEXTVAL

1401: if (l_option_flag <> 'Y') then
1402: For l_pay_element_rates_rec in l_pay_element_rates_csr
1403: Loop
1404:
1405: SELECT psb_pay_element_rates_s.NEXTVAL
1406: INTO l_pay_element_rate_id
1407: FROM DUAL;
1408:
1409: PSB_PAY_ELEMENT_RATES_PVT.INSERT_ROW

Line 1409: PSB_PAY_ELEMENT_RATES_PVT.INSERT_ROW

1405: SELECT psb_pay_element_rates_s.NEXTVAL
1406: INTO l_pay_element_rate_id
1407: FROM DUAL;
1408:
1409: PSB_PAY_ELEMENT_RATES_PVT.INSERT_ROW
1410: ( p_api_version => 1.0,
1411: p_init_msg_list => null,
1412: p_commit => null,
1413: p_validation_level => null,