APPS.PYJPEXC dependencies on PER_TIME_PERIODS

Line 100: per_time_periods ptp

96: --
97: select ptp.end_date
98: into p_expiry_information
99: from pay_payroll_actions ppa,
100: per_time_periods ptp
101: where ppa.payroll_action_id = p_owner_payroll_action_id
102: and ptp.time_period_id = ppa.time_period_id;
103: /*
104: --

Line 135: per_time_periods ptp_owner,

131: --
132: select least(max(asg.effective_end_date), ptp_owner.end_date)
133: into p_expiry_information
134: from per_all_assignments_f asg,
135: per_time_periods ptp_owner,
136: pay_payroll_actions ppa_owner,
137: pay_assignment_actions paa_owner
138: where paa_owner.assignment_action_id = p_owner_assignment_action_id
139: and ppa_owner.payroll_action_id = p_owner_payroll_action_id

Line 152: from per_time_periods ptp_user,

148: select ppa_owner.time_period_id,
149: ppa_user.time_period_id
150: into l_owner_time_period_id,
151: l_user_time_period_id
152: from per_time_periods ptp_user,
153: pay_payroll_actions ppa_user,
154: per_time_periods ptp_owner,
155: pay_payroll_actions ppa_owner
156: where ppa_owner.payroll_action_id = p_owner_payroll_action_id

Line 154: per_time_periods ptp_owner,

150: into l_owner_time_period_id,
151: l_user_time_period_id
152: from per_time_periods ptp_user,
153: pay_payroll_actions ppa_user,
154: per_time_periods ptp_owner,
155: pay_payroll_actions ppa_owner
156: where ppa_owner.payroll_action_id = p_owner_payroll_action_id
157: and ptp_owner.time_period_id = ppa_owner.time_period_id
158: and ppa_user.payroll_action_id = p_user_payroll_action_id