APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on PSB_SALARY_I

Line 1335: INSERT INTO PSB_SALARY_I

1331: Grade_rec.grade_spine_id);
1332:
1333: l_element_value := fnd_number.canonical_to_number(salary_rec.value);
1334:
1335: INSERT INTO PSB_SALARY_I
1336: ( BUSINESS_GROUP_ID,
1337: DATA_EXTRACT_ID,
1338: SALARY_TYPE ,
1339: RATE_OR_PAYSCALE_ID,

Line 1433: INSERT INTO PSB_SALARY_I

1429: l_mid_value := fnd_number.canonical_to_number(salary_rec.mid_value);
1430: l_element_value := fnd_number.canonical_to_number(salary_rec.value);
1431: l_sequence := salary_rec.sequence;
1432:
1433: INSERT INTO PSB_SALARY_I
1434: ( BUSINESS_GROUP_ID,
1435: DATA_EXTRACT_ID,
1436: SALARY_TYPE ,
1437: RATE_OR_PAYSCALE_ID,

Line 1783: FROM PSB_SALARY_I

1779: and rate_type = l_rate_type; */
1780:
1781: Cursor C_grade_rate is
1782: SELECT rate_or_payscale_id
1783: FROM PSB_SALARY_I
1784: WHERE GRADE_ID = l_grade_id
1785: and SALARY_TYPE = l_salary_type;
1786:
1787: /* Start bug No 3902996 */

Line 1791: FROM PSB_SALARY_I

1787: /* Start bug No 3902996 */
1788: CURSOR C_grade_rate_step
1789: IS
1790: SELECT rate_or_payscale_id
1791: FROM PSB_SALARY_I
1792: WHERE GRADE_ID = l_grade_id
1793: AND SALARY_TYPE = l_salary_type
1794: AND grade_step = l_grade_step;
1795: /* End bug no 3902996 */

Line 1801: FROM PSB_SALARY_I

1797:
1798: Cursor C_rate is
1799: SELECT rate_or_payscale_id,element_value,
1800: grade_step,sequence_number
1801: FROM PSB_SALARY_I
1802: WHERE RATE_OR_PAYSCALE_ID = l_rate_id
1803: AND GRADE_ID = l_grade_id
1804: AND SALARY_TYPE = l_salary_type
1805: AND DATA_EXTRACT_ID = p_data_extract_id;

Line 1809: FROM PSB_SALARY_I

1805: AND DATA_EXTRACT_ID = p_data_extract_id;
1806:
1807: Cursor C_Value is
1808: SELECT element_value
1809: FROM PSB_SALARY_I
1810: WHERE RATE_OR_PAYSCALE_ID = l_rate_or_payscale_id
1811: AND GRADE_ID = l_grade_id
1812: AND SALARY_TYPE = l_salary_type
1813: AND GRADE_STEP = l_grade_step

Line 2053: -- Getting rate_id from Psb_salary_i for employee_rec.grade_id

2049: End Loop;
2050:
2051: For C_rate_rec in C_rate
2052: Loop
2053: -- Getting rate_id from Psb_salary_i for employee_rec.grade_id
2054: l_rate_or_payscale_id := C_rate_rec.rate_or_payscale_id;
2055: l_element_value := C_rate_rec.element_value;
2056: l_grade_step := C_rate_rec.grade_step;
2057: l_sequence := C_rate_rec.sequence_number;