DBA Data[Home] [Help]

APPS.PAY_MAGTAPE_EXTRACT dependencies on PER_BUSINESS_GROUPS

Line 103: l_legislation_code per_business_groups.legislation_code%TYPE;

99: -- l_next_header Next header to be printed in report
100: --------------------------------------------------------------------------------
101: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
102: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
103: l_legislation_code per_business_groups.legislation_code%TYPE;
104: l_effective_date pay_payroll_actions.effective_date%TYPE;
105: l_date_earned pay_payroll_actions.date_earned%TYPE;
106: l_runmode VARCHAR2(1);
107: l_transmitter_tax_unit_id NUMBER;

Line 158: per_business_groups bg

154: l_effective_date,
155: l_date_earned,
156: legislative_parameters
157: FROM pay_payroll_actions pa,
158: per_business_groups bg
159: WHERE pa.payroll_action_id = l_payroll_action_id AND
160: pa.business_group_id = bg.business_group_id;
161: --
162: hr_utility.set_location ('arch_initialise',3);