APPS.HXT_PA_USER_EXITS dependencies on HXT_DET_HOURS_WORKED_X

Line 19: i_hours_worked -- HXT_det_hours_worked_x.hours

15:
16: Following is a list of parameters to the p_a_interface function and the source
17: of each argument:
18:
19: i_hours_worked -- HXT_det_hours_worked_x.hours
20: i_rate -- per_pay_proposals.proposed_salary
21: (employees hourly rate)
22: or
23: hxt_det_hours_worked_x.hourly_rate

Line 23: hxt_det_hours_worked_x.hourly_rate

19: i_hours_worked -- HXT_det_hours_worked_x.hours
20: i_rate -- per_pay_proposals.proposed_salary
21: (employees hourly rate)
22: or
23: hxt_det_hours_worked_x.hourly_rate
24: (timecard override hourly rate)
25: or
26: per_pay_proposals.proposed_salary *
27: (employees hourly rate)

Line 28: hxt_det_hours_worked_x.rate_multiple

24: (timecard override hourly rate)
25: or
26: per_pay_proposals.proposed_salary *
27: (employees hourly rate)
28: hxt_det_hours_worked_x.rate_multiple
29: (manually entered multiple from timecard)
30: or
31: per_pay_proposals.proposed_salary *
32: (employees hourly rate)

Line 38: hxt_det_hours_worked_x.hours

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
41: per_pay_proposals.proposed_salary *
42: (employees hourly rate)

Line 48: hxt_det_hours_worked_x.amount (timecard override amount)

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

Line 59: i_date_worked -- hxt_det_hours_worked_x.date_worked

55: --SIR162i_emp_cat_code -- per_assignments_f.employment_category
56:
57: i_oganization_name -- hr_organization_units.name
58: i_organization_id -- hr_organization_units.id
59: i_date_worked -- hxt_det_hours_worked_x.date_worked
60: i_effective_start_date -- hxt_det_hours_worked_x.effective_start_date
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

Line 60: i_effective_start_date -- hxt_det_hours_worked_x.effective_start_date

56:
57: i_oganization_name -- hr_organization_units.name
58: i_organization_id -- hr_organization_units.id
59: i_date_worked -- hxt_det_hours_worked_x.date_worked
60: i_effective_start_date -- hxt_det_hours_worked_x.effective_start_date
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

Line 61: i_effective_end_date -- hxt_det_hours_worked_x.effective_end_date

57: i_oganization_name -- hr_organization_units.name
58: i_organization_id -- hr_organization_units.id
59: i_date_worked -- hxt_det_hours_worked_x.date_worked
60: i_effective_start_date -- hxt_det_hours_worked_x.effective_start_date
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

Line 62: i_hours_type -- hxt_det_hours_worked_x.element_name

58: i_organization_id -- hr_organization_units.id
59: i_date_worked -- hxt_det_hours_worked_x.date_worked
60: i_effective_start_date -- hxt_det_hours_worked_x.effective_start_date
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

Line 64: i_time_detail_id -- hxt_det_hours_worked_x.id

60: i_effective_start_date -- hxt_det_hours_worked_x.effective_start_date
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

Line 70: i_project_id -- hxt_det_hours_worked_x.project_id

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)
70: i_project_id -- hxt_det_hours_worked_x.project_id
71: i_task_id -- hxt_det_hours_worked_x.task_id
72: i_segment1 -- pa_projects.segment1
73: i_task_number -- pa_tasks.task_number
74: i_project_name -- pa_projects.name

Line 71: i_task_id -- hxt_det_hours_worked_x.task_id

67: -- FALSE if Normal Transaction
68: i_standard_rate -- per_pay_proposals.proposed_salary
69: -- (employees unmodified base hourly rate)
70: i_project_id -- hxt_det_hours_worked_x.project_id
71: i_task_id -- hxt_det_hours_worked_x.task_id
72: i_segment1 -- pa_projects.segment1
73: i_task_number -- pa_tasks.task_number
74: i_project_name -- pa_projects.name
75: i_task_name -- pa_tasks.task_name

Line 208: FROM hxt_det_hours_worked_x det

204: SELECT for_person_id
205: INTO l_resource_id
206: FROM hxt_timecards_x tim
207: WHERE tim.id = (SELECT det.tim_id
208: FROM hxt_det_hours_worked_x det
209: WHERE det.id = i_time_detail_id
210: );
211: EXCEPTION
212: WHEN OTHERS THEN