APPS.PSB_PAY_ELEMENTS_PVT dependencies on PSB_PAY_ELEMENT_OPTIONS

Line 521: DELETE psb_pay_element_options

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 ;
523:
524: DELETE psb_pay_element_distributions
525: WHERE position_set_group_id IN

Line 1139: FROM psb_pay_element_options

1135:
1136: CURSOR l_pay_element_options_csr is
1137: SELECT pay_element_option_id,pay_element_id,
1138: name, grade_step, sequence_number
1139: FROM psb_pay_element_options
1140: WHERE pay_element_id = p_source_pay_element_id;
1141:
1142: CURSOR l_pay_element_rates_csr is
1143: SELECT pay_element_rate_id,pay_element_option_id,

Line 1314: SELECT psb_pay_element_options_s.NEXTVAL

1310:
1311: l_source_pay_element_option_id :=
1312: l_pay_element_options_rec.pay_element_option_id;
1313:
1314: SELECT psb_pay_element_options_s.NEXTVAL
1315: INTO l_pay_element_option_id
1316: FROM DUAL;
1317:
1318: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW

Line 1318: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW

1314: SELECT psb_pay_element_options_s.NEXTVAL
1315: INTO l_pay_element_option_id
1316: FROM DUAL;
1317:
1318: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW
1319: ( p_api_version => 1.0,
1320: p_init_msg_list => null,
1321: p_commit => null,
1322: p_validation_level => null,