APPS.PSB_HR_POPULATE_DATA_PVT dependencies on PSB_PAY_ELEMENT_RATES

Line 354: FROM psb_pay_element_rates

350: effective_start_DATE,
351: effective_END_DATE,
352: element_value,
353: currency_code
354: FROM psb_pay_element_rates
355: WHERE pay_element_id = l_pay_element_id
356: AND pay_element_option_id = l_pay_element_option_id;
357:
358: l_last_update_date DATE;

Line 585: Select psb_pay_element_rates_s.nextval

581: RAISE FND_API.G_EXC_ERROR;
582: END IF;
583:
584:
585: Select psb_pay_element_rates_s.nextval
586: INTO l_pay_element_rate_id
587: FROM dual;
588:
589: For C_Currency_Rec in C_Currency

Line 594: PSB_PAY_ELEMENT_RATES_PVT.INSERT_ROW

590: Loop
591: l_currency_code := C_Currency_Rec.currency_code;
592: End Loop;
593:
594: PSB_PAY_ELEMENT_RATES_PVT.INSERT_ROW
595: ( p_api_version => 1.0,
596: p_init_msg_list => NULL,
597: p_commit => NULL,
598: p_validation_level => NULL,

Line 5675: FROM psb_pay_element_rates

5671: effective_start_date,
5672: effective_end_date,
5673: element_value,
5674: currency_code
5675: FROM psb_pay_element_rates
5676: WHERE pay_element_id = l_pay_element_id
5677: AND pay_element_option_id = l_pay_element_option_id;
5678:
5679: /* start bug 4213882 */

Line 7111: FROM psb_pay_element_rates

7107: effective_start_DATE,
7108: effective_END_DATE,
7109: element_value,
7110: currency_code
7111: FROM psb_pay_element_rates
7112: WHERE pay_element_id = l_ppay_element_id
7113: AND pay_element_option_id = l_ppay_element_option_id;
7114:
7115: Cursor C_non_grade_salary IS

Line 8185: PSB_PAY_ELEMENT_RATES_PVT.ModIFy_Element_Rates

8181: );
8182:
8183: END IF;
8184:
8185: PSB_PAY_ELEMENT_RATES_PVT.ModIFy_Element_Rates
8186: ( p_api_version => 1.0,
8187: p_init_msg_lISt => NULL,
8188: p_commit => NULL,
8189: p_validation_level => NULL,

Line 8307: Select psb_pay_element_rates_s.nextval

8303: RAISE FND_API.G_EXC_ERROR;
8304: END IF;
8305:
8306:
8307: Select psb_pay_element_rates_s.nextval
8308: INTO l_pay_element_rate_id
8309: FROM dual;
8310:
8311: PSB_PAY_ELEMENT_RATES_PVT.INSERT_ROW

Line 8311: PSB_PAY_ELEMENT_RATES_PVT.INSERT_ROW

8307: Select psb_pay_element_rates_s.nextval
8308: INTO l_pay_element_rate_id
8309: FROM dual;
8310:
8311: PSB_PAY_ELEMENT_RATES_PVT.INSERT_ROW
8312: ( p_api_version => 1.0,
8313: p_init_msg_lISt => NULL,
8314: p_commit => NULL,
8315: p_validation_level => NULL,