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.

[Home] [Help]

APPS.PSB_HR_POPULATE_DATA_PVT dependencies on PSB_PAY_ELEMENTS

Line 327: FROM psb_pay_elements ppe,

323:
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

Line 340: FROM psb_pay_elements ppe,

336:
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

Line 489: Select psb_pay_elements_s.nextval INTO l_pay_element_id

485:
486: end if;
487:
488: if (l_pay_element_id is null) then
489: Select psb_pay_elements_s.nextval INTO l_pay_element_id
490: FROM dual;
491:
492: PSB_PAY_ELEMENTS_PVT.INSERT_ROW
493: ( p_api_version => 1.0,

Line 492: PSB_PAY_ELEMENTS_PVT.INSERT_ROW

488: if (l_pay_element_id is null) then
489: Select psb_pay_elements_s.nextval INTO l_pay_element_id
490: FROM dual;
491:
492: PSB_PAY_ELEMENTS_PVT.INSERT_ROW
493: ( p_api_version => 1.0,
494: p_init_msg_lISt => NULL,
495: p_commit => NULL,
496: p_validation_level => NULL,

Line 5648: FROM psb_pay_elements ppe,

5644:
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

Line 5661: FROM psb_pay_elements ppe,

5657:
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

Line 5687: psb_pay_elements pe

5683: IS
5684: SELECT pas.position_assignment_id
5685: FROM psb_position_assignments pas, -- bug #4886277: Used the table
5686: -- instead of View.
5687: psb_pay_elements pe
5688: WHERE pas.pay_element_id = pe.pay_element_id (+)
5689: AND pas.assignment_type = 'ELEMENT'
5690: AND pas.data_extract_id = p_data_extract_id
5691: AND pas.position_id = vc_position_id

Line 7070: FROM psb_pay_elements ppe,

7066:
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

Line 7083: FROM psb_pay_elements ppe,

7079:
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

Line 7117: FROM psb_pay_elements

7113: AND pay_element_option_id = l_ppay_element_option_id;
7114:
7115: Cursor C_non_grade_salary IS
7116: Select pay_element_id
7117: FROM psb_pay_elements
7118: WHERE data_extract_id = p_data_extract_id
7119: AND option_flag = 'N'
7120: AND overwrite_flag = 'Y'
7121: AND name = l_non_grade_salary_name;

Line 7322: Select psb_pay_elements_s.nextval INTO ln_pay_element_id

7318:
7319: -- Create a pay element.
7320: IF (ln_pay_element_id = 0) THEN
7321:
7322: Select psb_pay_elements_s.nextval INTO ln_pay_element_id
7323: FROM dual;
7324:
7325: PSB_PAY_ELEMENTS_PVT.INSERT_ROW
7326: ( p_api_version => 1.0,

Line 7325: PSB_PAY_ELEMENTS_PVT.INSERT_ROW

7321:
7322: Select psb_pay_elements_s.nextval INTO ln_pay_element_id
7323: FROM dual;
7324:
7325: PSB_PAY_ELEMENTS_PVT.INSERT_ROW
7326: ( p_api_version => 1.0,
7327: p_init_msg_lISt => NULL,
7328: p_commit => NULL,
7329: p_validation_level => NULL,

Line 7897: FROM psb_pay_elements

7893: ORDER BY rate_or_payscale_id, salary_type;
7894:
7895: Cursor C_Refresh IS
7896: Select rowid,pay_element_id, budget_set_id,period_type
7897: FROM psb_pay_elements
7898: WHERE data_extract_id = p_data_extract_id
7899: AND name = lr_rate_or_payscale_name
7900: AND salary_type = lr_salary_type;
7901:

Line 8035: PSB_PAY_ELEMENTS_PVT.UPDATE_ROW

8031: IF ((C_Element_Rec.rate_or_payscale_id <> prev_rate_or_payscale_id)
8032: or (C_Element_Rec.salary_type <> prev_salary_type)
8033: or (prev_salary_type = 'X')
8034: or (prev_rate_or_payscale_id = -1)) THEN
8035: PSB_PAY_ELEMENTS_PVT.UPDATE_ROW
8036: ( p_api_version => 1.0,
8037: p_init_msg_lISt => NULL,
8038: p_commit => NULL,
8039: p_validation_level => NULL,

Line 8220: Select psb_pay_elements_s.nextval

8216: or (C_Element_Rec.salary_type <> prev_salary_type)
8217: or (prev_salary_type = 'X')
8218: or (prev_rate_or_payscale_id = -1)) THEN
8219:
8220: Select psb_pay_elements_s.nextval
8221: INTO l_pay_element_id
8222: FROM dual;
8223:
8224: PSB_PAY_ELEMENTS_PVT.INSERT_ROW

Line 8224: PSB_PAY_ELEMENTS_PVT.INSERT_ROW

8220: Select psb_pay_elements_s.nextval
8221: INTO l_pay_element_id
8222: FROM dual;
8223:
8224: PSB_PAY_ELEMENTS_PVT.INSERT_ROW
8225: ( p_api_version => 1.0,
8226: p_init_msg_lISt => NULL,
8227: p_commit => NULL,
8228: p_validation_level => NULL,