APPS.PSB_HR_POPULATE_DATA_PVT dependencies on PSB_SALARY_I

Line 5631: FROM psb_salary_i

5627: l_last_success_flag varchar2(1):='Y';
5628: --
5629: Cursor C_salary IS
5630: Select rate_or_payscale_name,grade_name
5631: FROM psb_salary_i
5632: WHERE rate_or_payscale_id = l_rate_or_payscale_id
5633: AND grade_id = l_grade_id
5634: AND grade_step = l_grade_step
5635: AND sequence_number = l_sequence_number

Line 5640: FROM psb_salary_i

5636: AND data_extract_id = p_data_extract_id;
5637:
5638: Cursor C_rate_salary IS
5639: Select rate_or_payscale_name,grade_name
5640: FROM psb_salary_i
5641: WHERE rate_or_payscale_id = l_rate_or_payscale_id
5642: AND grade_id = l_grade_id
5643: AND data_extract_id = p_data_extract_id;
5644:

Line 7053: FROM psb_salary_i

7049: WHERE set_of_books_id = p_set_of_books_id;
7050:
7051: Cursor C_salary IS
7052: Select rate_or_payscale_name,grade_name
7053: FROM psb_salary_i
7054: WHERE rate_or_payscale_id = prev_rate_or_payscale_id
7055: AND grade_id = prev_grade_id
7056: AND grade_step = prev_grade_step
7057: AND sequence_number = prev_sequence_number

Line 7062: FROM psb_salary_i

7058: AND data_extract_id = p_data_extract_id;
7059:
7060: Cursor C_rate_salary IS
7061: Select rate_or_payscale_name,grade_name
7062: FROM psb_salary_i
7063: WHERE rate_or_payscale_id = prev_rate_or_payscale_id
7064: AND grade_id = prev_grade_id
7065: AND data_extract_id = p_data_extract_id;
7066:

Line 7890: FROM psb_salary_i

7886: minimum_value, maximum_value,
7887: mid_value, element_value,pay_basIS,
7888: element_type_id,
7889: effective_start_DATE, effective_END_DATE
7890: FROM psb_salary_i
7891: WHERE data_extract_id = p_data_extract_id
7892: AND rate_or_payscale_id > l_restart_salary_id
7893: ORDER BY rate_or_payscale_id, salary_type;
7894: