APPS.PAY_GB_P11D_MAGTAPE dependencies on PAY_PAYROLL_ACTIONS

Line 39: from pay_payroll_actions

35: business_group_id,
36: request_id,
37: start_date,
38: effective_date -- this will be the benefit end date
39: from pay_payroll_actions
40: where payroll_action_id = p_pact_id;
41:
42: cursor csr_org_info(p_business_group_id number,
43: p_tax_ref varchar2)

Line 157: pay_payroll_actions ppa

153: -- the string, and the statement must be, order by person_id
154: --
155: sqlstr := 'SELECT DISTINCT person_id
156: FROM per_people_f ppf,
157: pay_payroll_actions ppa
158: WHERE ppa.payroll_action_id = :payroll_action_id
159: AND ppa.business_group_id +0= ppf.business_group_id
160: ORDER BY ppf.person_id';
161:

Line 206: l_arch_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

202:
203: --
204: l_ass_act_id pay_assignment_actions.assignment_action_id%TYPE;
205: l_proc CONSTANT VARCHAR2(35) := g_package || 'action_creation';
206: l_arch_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
207: l_tax_ref varchar2(30);
208: BEGIN
209: --
210: hr_utility.set_location ('Entering: ' || l_proc, 1);