APPS.HXT_PA_USER_EXITS dependencies on HXT_PAY_ELEMENT_TYPES_F_DDF_V

Line 33: hxt_pay_element_types_f_ddf_v.hxt_premium_amount

29: (manually entered multiple from timecard)
30: or
31: per_pay_proposals.proposed_salary *
32: (employees hourly rate)
33: hxt_pay_element_types_f_ddf_v.hxt_premium_amount
34: (multiple from pay element flex)
35: or
36: hxt_pay_element_types_f_ddf_v.hxt_premium_amount/
37: (daily amount from element flex)

Line 36: hxt_pay_element_types_f_ddf_v.hxt_premium_amount/

32: (employees hourly rate)
33: hxt_pay_element_types_f_ddf_v.hxt_premium_amount
34: (multiple from pay element flex)
35: or
36: hxt_pay_element_types_f_ddf_v.hxt_premium_amount/
37: (daily amount from element flex)
38: hxt_det_hours_worked_x.hours
39: (hours worked)
40: or

Line 43: hxt_pay_element_types_f_ddf_v.hxt_premium_amount - 1.0

39: (hours worked)
40: or
41: per_pay_proposals.proposed_salary *
42: (employees hourly rate)
43: hxt_pay_element_types_f_ddf_v.hxt_premium_amount - 1.0
44: (non-ot premium multiple from pay element flex minus 1.0)
45: i_premium_amount -- hxt_pay_element_types_f_ddf_v.hxt_premium_amount
46: (premium amount element flex)
47: or

Line 45: i_premium_amount -- hxt_pay_element_types_f_ddf_v.hxt_premium_amount

41: per_pay_proposals.proposed_salary *
42: (employees hourly rate)
43: hxt_pay_element_types_f_ddf_v.hxt_premium_amount - 1.0
44: (non-ot premium multiple from pay element flex minus 1.0)
45: i_premium_amount -- hxt_pay_element_types_f_ddf_v.hxt_premium_amount
46: (premium amount element flex)
47: or
48: hxt_det_hours_worked_x.amount (timecard override amount)
49: i_trans_source -- hxt_pay_element_types_f_ddf_v.hxt_earning_category

Line 49: i_trans_source -- hxt_pay_element_types_f_ddf_v.hxt_earning_category

45: i_premium_amount -- hxt_pay_element_types_f_ddf_v.hxt_premium_amount
46: (premium amount element flex)
47: or
48: hxt_det_hours_worked_x.amount (timecard override amount)
49: i_trans_source -- hxt_pay_element_types_f_ddf_v.hxt_earning_category
50: ||hxt_pay_element_types_f_ddf_v.hxt_premium_type
51: i_period_end -- per_time_periods.end_date
52: i_employee_number-- per_people_f.employee_number
53:

Line 50: ||hxt_pay_element_types_f_ddf_v.hxt_premium_type

46: (premium amount element flex)
47: or
48: hxt_det_hours_worked_x.amount (timecard override amount)
49: i_trans_source -- hxt_pay_element_types_f_ddf_v.hxt_earning_category
50: ||hxt_pay_element_types_f_ddf_v.hxt_premium_type
51: i_period_end -- per_time_periods.end_date
52: i_employee_number-- per_people_f.employee_number
53:
54: --SIR162i_employment_cat -- fnd_common_lookups.meaning(lookup_type = 'EMP_CAT')

Line 65: i_hxt_earning_category -- hxt_pay_element_types_f_ddf_v.hxt_earning_category

61: i_effective_end_date -- hxt_det_hours_worked_x.effective_end_date
62: i_hours_type -- hxt_det_hours_worked_x.element_name
63: i_salary_basis -- per_pay_proposals_v.pay_basis
64: i_time_detail_id -- hxt_det_hours_worked_x.id
65: i_hxt_earning_category -- hxt_pay_element_types_f_ddf_v.hxt_earning_category
66: i_retro_transaction -- TRUE if Retro Transaction
67: -- FALSE if Normal Transaction
68: i_standard_rate -- per_pay_proposals.proposed_salary
69: -- (employees unmodified base hourly rate)

Line 172: -- FROM hxt_pay_element_types_f_ddf_v eltv

168:
169: -- BEGIN GLOBAL
170: -- CURSOR exp_type IS
171: -- SELECT eltv.hxt_expenditure_type
172: -- FROM hxt_pay_element_types_f_ddf_v eltv
173: -- ,pay_element_types_f elt
174: -- where elt.element_type_id = i_element_type_id
175: -- and eltv.row_id = elt.rowid;
176:

Line 179: FROM hxt_pay_element_types_f_ddf_v eltv

175: -- and eltv.row_id = elt.rowid;
176:
177: CURSOR exp_type IS
178: SELECT eltv.hxt_expenditure_type
179: FROM hxt_pay_element_types_f_ddf_v eltv
180: WHERE eltv.element_type_id = i_element_type_id
181: AND i_date_worked BETWEEN eltv.effective_start_date
182: AND eltv.effective_end_date;
183: -- END GLOBAL