DBA Data[Home] [Help]

APPS.PAY_MAGTAPE_EXTRACT dependencies on PAY_PAYROLL_ACTIONS

Line 101: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

97: -- l_state State code (eg 'CA')
98: -- l_last_context Last context to be printed in report
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;

Line 102: l_business_group_id pay_payroll_actions.business_group_id%TYPE;

98: -- l_last_context Last context to be printed in report
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);

Line 104: l_effective_date pay_payroll_actions.effective_date%TYPE;

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;
108: l_report_format VARCHAR2(32);

Line 105: l_date_earned pay_payroll_actions.date_earned%TYPE;

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;
108: l_report_format VARCHAR2(32);
109: l_report_type VARCHAR2(32);

Line 131: legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;

127: -- legislative_parameters Legislative parameters
128: --==============================================================================
129: PROCEDURE arch_initialise (p_payroll_action_id NUMBER) IS
130: jurisdiction_code pay_state_rules.jurisdiction_code%TYPE;
131: legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
132: BEGIN
133: hr_utility.set_location ('arch_initialise',1);
134: --
135: l_payroll_action_id := p_payroll_action_id;

Line 157: FROM pay_payroll_actions pa,

153: l_legislation_code,
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: --