APPS.PAY_JP_PRE_TAX_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 68: p_date_start OUT NOCOPY per_periods_of_service.date_start%TYPE,

64: p_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
65: p_effective_date IN pay_payroll_actions.effective_date%TYPE,
66: p_person_id OUT NOCOPY per_all_assignments_f.person_id%TYPE,
67: p_period_of_service_id OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE,
68: p_date_start OUT NOCOPY per_periods_of_service.date_start%TYPE,
69: p_leaving_reason OUT NOCOPY per_periods_of_service.leaving_reason%TYPE,
70: p_actual_termination_date OUT NOCOPY per_periods_of_service.actual_termination_date%TYPE,
71: p_employment_category OUT NOCOPY per_all_assignments_f.employment_category%TYPE)
72: IS

Line 69: p_leaving_reason OUT NOCOPY per_periods_of_service.leaving_reason%TYPE,

65: p_effective_date IN pay_payroll_actions.effective_date%TYPE,
66: p_person_id OUT NOCOPY per_all_assignments_f.person_id%TYPE,
67: p_period_of_service_id OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE,
68: p_date_start OUT NOCOPY per_periods_of_service.date_start%TYPE,
69: p_leaving_reason OUT NOCOPY per_periods_of_service.leaving_reason%TYPE,
70: p_actual_termination_date OUT NOCOPY per_periods_of_service.actual_termination_date%TYPE,
71: p_employment_category OUT NOCOPY per_all_assignments_f.employment_category%TYPE)
72: IS
73:

Line 70: p_actual_termination_date OUT NOCOPY per_periods_of_service.actual_termination_date%TYPE,

66: p_person_id OUT NOCOPY per_all_assignments_f.person_id%TYPE,
67: p_period_of_service_id OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE,
68: p_date_start OUT NOCOPY per_periods_of_service.date_start%TYPE,
69: p_leaving_reason OUT NOCOPY per_periods_of_service.leaving_reason%TYPE,
70: p_actual_termination_date OUT NOCOPY per_periods_of_service.actual_termination_date%TYPE,
71: p_employment_category OUT NOCOPY per_all_assignments_f.employment_category%TYPE)
72: IS
73:
74: BEGIN

Line 91: per_periods_of_service pds

87: p_leaving_reason,
88: p_actual_termination_date,
89: p_employment_category
90: from per_all_assignments_f asg,
91: per_periods_of_service pds
92: where asg.assignment_id = p_assignment_id
93: and p_effective_date between asg.effective_start_date and asg.effective_end_date
94: and pds.period_of_service_id = asg.period_of_service_id;
95:

Line 120: l_date_start per_periods_of_service.date_start%TYPE;

116: l_action_status VARCHAR2(1);
117: l_message VARCHAR2(255);
118: l_person_id per_all_assignments_f.person_id%TYPE;
119: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
120: l_date_start per_periods_of_service.date_start%TYPE;
121: l_leaving_reason per_periods_of_service.leaving_reason%TYPE;
122: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
123: l_employment_category per_all_assignments_f.employment_category%TYPE;
124:

Line 121: l_leaving_reason per_periods_of_service.leaving_reason%TYPE;

117: l_message VARCHAR2(255);
118: l_person_id per_all_assignments_f.person_id%TYPE;
119: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
120: l_date_start per_periods_of_service.date_start%TYPE;
121: l_leaving_reason per_periods_of_service.leaving_reason%TYPE;
122: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
123: l_employment_category per_all_assignments_f.employment_category%TYPE;
124:
125: l_action_info_id1 pay_action_information.action_information_id%TYPE;

Line 122: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

118: l_person_id per_all_assignments_f.person_id%TYPE;
119: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
120: l_date_start per_periods_of_service.date_start%TYPE;
121: l_leaving_reason per_periods_of_service.leaving_reason%TYPE;
122: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
123: l_employment_category per_all_assignments_f.employment_category%TYPE;
124:
125: l_action_info_id1 pay_action_information.action_information_id%TYPE;
126: l_action_info_id2 pay_action_information.action_information_id%TYPE;