eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_HR_POPULATE_DATA_PVT dependencies on PSB_PAY_ELEMENT_OPTIONS

Line 328: psb_pay_element_options ppo

324: Cursor C_pay_elements_step IS
325: Select ppe.pay_element_id ,ppe.salary_type,
326: ppo.pay_element_option_id
327: FROM psb_pay_elements ppe,
328: psb_pay_element_options ppo
329: WHERE ppe.data_extract_id = p_data_extract_id
330: AND ppe.salary_type = 'STEP'
331: AND ppe.name = l_rate_or_payscale_name
332: AND ppe.pay_element_id = ppo.pay_element_id

Line 341: psb_pay_element_options ppo

337: Cursor C_pay_elements_rate IS
338: Select ppe.pay_element_id ,ppe.salary_type,
339: ppo.pay_element_option_id
340: FROM psb_pay_elements ppe,
341: psb_pay_element_options ppo
342: WHERE ppe.data_extract_id = p_data_extract_id
343: AND ppe.salary_type = 'RATE'
344: AND ppe.name = l_rate_or_payscale_name
345: AND ppe.pay_element_id = ppo.pay_element_id

Line 556: Select psb_pay_element_options_s.nextval

552: l_last_update_login := FND_GLOBAL.LOGIN_ID;
553: l_creation_date := sysdate;
554: l_created_by := FND_GLOBAL.USER_ID; */
555:
556: Select psb_pay_element_options_s.nextval
557: INTO l_pay_element_option_id
558: FROM dual;
559:
560: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW

Line 560: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW

556: Select psb_pay_element_options_s.nextval
557: INTO l_pay_element_option_id
558: FROM dual;
559:
560: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW
561: ( p_api_version => 1.0,
562: p_init_msg_list => NULL,
563: p_commit => NULL,
564: p_validation_level => NULL,

Line 5649: psb_pay_element_options ppo

5645: Cursor C_pay_elements_step IS
5646: Select ppe.pay_element_id ,ppe.salary_type,
5647: ppo.pay_element_option_id
5648: FROM psb_pay_elements ppe,
5649: psb_pay_element_options ppo
5650: WHERE ppe.data_extract_id = p_data_extract_id
5651: AND ppe.salary_type = 'STEP'
5652: AND ppe.name = l_rate_or_payscale_name
5653: AND ppe.pay_element_id = ppo.pay_element_id

Line 5662: psb_pay_element_options ppo

5658: Cursor C_pay_elements_rate IS
5659: Select ppe.pay_element_id ,ppe.salary_type,
5660: ppo.pay_element_option_id
5661: FROM psb_pay_elements ppe,
5662: psb_pay_element_options ppo
5663: WHERE ppe.data_extract_id = p_data_extract_id
5664: AND ppe.salary_type = 'RATE'
5665: AND ppe.name = l_rate_or_payscale_name
5666: AND ppe.pay_element_id = ppo.pay_element_id

Line 7071: psb_pay_element_options ppo

7067: Cursor C_pay_elements_step IS
7068: Select ppe.pay_element_id ,ppe.salary_type,
7069: ppo.pay_element_option_id
7070: FROM psb_pay_elements ppe,
7071: psb_pay_element_options ppo
7072: WHERE ppe.data_extract_id = p_data_extract_id
7073: AND ppe.salary_type = 'STEP'
7074: AND ppe.name = prev_rate_or_payscale_name
7075: AND ppe.pay_element_id = ppo.pay_element_id

Line 7084: psb_pay_element_options ppo

7080: Cursor C_pay_elements_rate IS
7081: Select ppe.pay_element_id ,ppe.salary_type,
7082: ppo.pay_element_option_id
7083: FROM psb_pay_elements ppe,
7084: psb_pay_element_options ppo
7085: WHERE ppe.data_extract_id = p_data_extract_id
7086: AND ppe.salary_type = 'RATE'
7087: AND ppe.name = prev_rate_or_payscale_name
7088: AND ppe.pay_element_id = ppo.pay_element_id

Line 7093: FROM psb_pay_element_options

7089: AND ppo.name = prev_grade_name;
7090:
7091: /*Cursor C_pay_element_options IS
7092: Select pay_element_option_id
7093: FROM psb_pay_element_options
7094: WHERE pay_element_id = l_ppay_element_id
7095: AND name = prev_grade_name
7096: AND grade_step = prev_grade_step
7097: AND sequence_number = prev_sequence_number;

Line 7101: FROM psb_pay_element_options

7097: AND sequence_number = prev_sequence_number;
7098:
7099: Cursor C_pay_element_rate_options IS
7100: Select pay_element_option_id
7101: FROM psb_pay_element_options
7102: WHERE pay_element_id = l_ppay_element_id
7103: AND name = prev_grade_name; */
7104:
7105: Cursor C_pay_element_rates IS

Line 7923: FROM PSB_PAY_ELEMENT_OPTIONS

7919: l_salary_ctr number := 0;
7920:
7921: Cursor C_Ref_Option IS
7922: Select rowid, pay_element_option_id
7923: FROM PSB_PAY_ELEMENT_OPTIONS
7924: WHERE pay_element_id = l_pay_element_id
7925: AND name = lr_grade_name
7926: AND grade_step = lr_grade_step
7927: AND sequence_number = lr_sequence_number;

Line 7931: FROM PSB_PAY_ELEMENT_OPTIONS

7927: AND sequence_number = lr_sequence_number;
7928:
7929: Cursor C_Ref_Rate_Option IS
7930: Select rowid, pay_element_option_id
7931: FROM PSB_PAY_ELEMENT_OPTIONS
7932: WHERE pay_element_id = l_pay_element_id
7933: AND name = lr_grade_name;
7934: Begin
7935:

Line 8105: PSB_PAY_ELEMENT_OPTIONS_PVT.UPDATE_ROW

8101: FOR C_Ref_Option_Rec in C_Ref_Option
8102: LOOP
8103: l_option_dummy := 1;
8104: l_pay_element_option_id := C_Ref_Option_Rec.pay_element_option_id;
8105: PSB_PAY_ELEMENT_OPTIONS_PVT.UPDATE_ROW
8106: ( p_api_version => 1.0,
8107: p_init_msg_lISt => NULL,
8108: p_commit => NULL,
8109: p_validation_level => NULL,

Line 8134: PSB_PAY_ELEMENT_OPTIONS_PVT.UPDATE_ROW

8130: FOR C_Ref_Rate_Rec in C_Ref_Rate_Option
8131: LOOP
8132: l_option_dummy := 1;
8133: l_pay_element_option_id := C_Ref_Rate_Rec.pay_element_option_id;
8134: PSB_PAY_ELEMENT_OPTIONS_PVT.UPDATE_ROW
8135: ( p_api_version => 1.0,
8136: p_init_msg_lISt => NULL,
8137: p_commit => NULL,
8138: p_validation_level => NULL,

Line 8159: Select psb_pay_element_options_s.nextval

8155: END LOOP;
8156: END IF;
8157:
8158: IF (l_option_dummy = 0) THEN
8159: Select psb_pay_element_options_s.nextval
8160: INTO l_pay_element_option_id
8161: FROM dual;
8162:
8163: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW

Line 8163: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW

8159: Select psb_pay_element_options_s.nextval
8160: INTO l_pay_element_option_id
8161: FROM dual;
8162:
8163: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW
8164: ( p_api_version => 1.0,
8165: p_init_msg_lISt => NULL,
8166: p_commit => NULL,
8167: p_validation_level => NULL,

Line 8278: Select psb_pay_element_options_s.nextval

8274: RAISE FND_API.G_EXC_ERROR;
8275: END IF;
8276: END IF;
8277:
8278: Select psb_pay_element_options_s.nextval
8279: INTO l_pay_element_option_id
8280: FROM dual;
8281:
8282: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW

Line 8282: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW

8278: Select psb_pay_element_options_s.nextval
8279: INTO l_pay_element_option_id
8280: FROM dual;
8281:
8282: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW
8283: ( p_api_version => 1.0,
8284: p_init_msg_lISt => NULL,
8285: p_commit => NULL,
8286: p_validation_level => NULL,