APPS.GHR_SF113_A dependencies on GHR_PAYROLL

Line 1132: GHR_PAYROLL gp,

1128: pa.effective_start_date,
1129: past.per_system_status
1130: FROM per_assignments_f pa,
1131: per_assignment_status_types past,
1132: GHR_PAYROLL gp,
1133: HR_ALL_POSITIONS_F pp,
1134: PER_POSITION_DEFINITIONS ppd,
1135: GHR_DUTY_STATIONS_F hds,
1136: HR_LOCATION_EXTRA_INFO hlei,

Line 1998: FROM ghr_payroll

1994: AND int.date_from BETWEEN p_pay_from and p_pay_to;
1995:
1996: CURSOR c_numb (l_person_id NUMBER) IS
1997: SELECT count(*)
1998: FROM ghr_payroll
1999: WHERE date_from = p_pay_from
2000: AND person_id = l_person_id;
2001:
2002: BEGIN

Line 2008: INSERT INTO ghr_payroll

2004: OPEN c_numb (to_number(cr_rec.person_id));
2005: FETCH c_numb into l_count;
2006: CLOSE c_numb;
2007: IF l_count = 0 THEN
2008: INSERT INTO ghr_payroll
2009: (PAYROLL_ID, PERSON_ID,
2010: DATE_FROM, DATE_TO,
2011: TOTAL_SALARY_AMOUNT, LUMP_SUM_AMOUNT)
2012: VALUES (ghr_payroll_s.nextval, to_number(cr_rec.person_id),

Line 2012: VALUES (ghr_payroll_s.nextval, to_number(cr_rec.person_id),

2008: INSERT INTO ghr_payroll
2009: (PAYROLL_ID, PERSON_ID,
2010: DATE_FROM, DATE_TO,
2011: TOTAL_SALARY_AMOUNT, LUMP_SUM_AMOUNT)
2012: VALUES (ghr_payroll_s.nextval, to_number(cr_rec.person_id),
2013: cr_rec.pay_from, cr_rec.pay_to,
2014: to_number(cr_rec.total_pay), to_number(cr_rec.lump_sum));
2015: ELSE
2016: UPDATE ghr_payroll

Line 2016: UPDATE ghr_payroll

2012: VALUES (ghr_payroll_s.nextval, to_number(cr_rec.person_id),
2013: cr_rec.pay_from, cr_rec.pay_to,
2014: to_number(cr_rec.total_pay), to_number(cr_rec.lump_sum));
2015: ELSE
2016: UPDATE ghr_payroll
2017: SET total_salary_amount = to_number(cr_rec.total_pay),
2018: lump_sum_amount = to_number(cr_rec.lump_sum)
2019: WHERE date_from = p_pay_from
2020: AND person_id = to_number(cr_rec.person_id);