APPS.PYJPEXC dependencies on PAY_PAYROLL_ACTIONS

Line 60: from pay_payroll_actions ppa_user,

56: select ppa_owner.time_period_id,
57: ppa_user.time_period_id
58: into l_owner_time_period_id,
59: l_user_time_period_id
60: from pay_payroll_actions ppa_user,
61: pay_payroll_actions ppa_owner
62: where ppa_owner.payroll_action_id = p_owner_payroll_action_id
63: and ppa_user.payroll_action_id = p_user_payroll_action_id;
64: --

Line 61: pay_payroll_actions ppa_owner

57: ppa_user.time_period_id
58: into l_owner_time_period_id,
59: l_user_time_period_id
60: from pay_payroll_actions ppa_user,
61: pay_payroll_actions ppa_owner
62: where ppa_owner.payroll_action_id = p_owner_payroll_action_id
63: and ppa_user.payroll_action_id = p_user_payroll_action_id;
64: --
65: -- Note this expiry checking mechanism has bug.2646992

Line 99: from pay_payroll_actions ppa,

95: hr_utility.set_location('Entering : ' || c_proc, 10);
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: /*

Line 136: pay_payroll_actions ppa_owner,

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
140: and ptp_owner.time_period_id = ppa_owner.time_period_id

Line 153: pay_payroll_actions ppa_user,

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
157: and ptp_owner.time_period_id = ppa_owner.time_period_id

Line 155: pay_payroll_actions ppa_owner

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
159: and ptp_user.time_period_id = ppa_user.time_period_id;

Line 607: from pay_payroll_actions

603: hr_utility.trace('cache NOT available');
604: --
605: select business_group_id
606: into l_business_group_id
607: from pay_payroll_actions
608: where payroll_action_id = p_payroll_action_id;
609: --
610: -- Cache the business_group_id of current payroll action
611: --