APPS.PAY_CA_ARCHIVE_RULES dependencies on PAY_PAYROLL_ACTIONS

Line 60: from pay_payroll_actions ppa

56:
57: hr_utility.trace('PACTID = '||to_char(pactid));
58: select ppa.legislative_parameters
59: into lv_legislative_param
60: from pay_payroll_actions ppa
61: where payroll_action_id = pactid;
62: l_pre_organization_id := pay_core_utils.get_parameter('TRANSFER_PRE',lv_legislative_param);
63: l_gre_id := pay_core_utils.get_parameter('TRANSFER_GRE',lv_legislative_param);
64:

Line 110: FROM pay_payroll_actions

106: INTO ld_effective_date,
107: ln_tax_unit_id,
108: l_pre_organization_id,
109: l_report_type
110: FROM pay_payroll_actions
111: WHERE payroll_action_id = pactid;
112:
113: ld_year_end := add_months(trunc(ld_effective_date, 'Y'),12) -1;
114: hr_utility.trace('year end '|| to_char(ld_year_end,'dd-mm-yyyy'));

Line 129: FROM pay_payroll_actions ppa,

125: and PAA.tax_unit_id=hoi.organization_id
126: )';
127: end if;
128: sqlstr := sqlstr ||'AND not exists (SELECT 1
129: FROM pay_payroll_actions ppa,
130: pay_assignment_actions paa
131: WHERE ppa.report_type = ''' || l_report_type ||
132: ''' AND ppa.action_status = ''C''
133: AND ppa.effective_date = '''|| ld_year_end ||'''

Line 175: from pay_payroll_actions ppa

171:
172: hr_utility.trace('PACTID = '||to_char(pactid));
173: select ppa.legislative_parameters
174: into lv_legislative_param
175: from pay_payroll_actions ppa
176: where payroll_action_id = pactid;
177: l_pre_organization_id := pay_core_utils.get_parameter('TRANSFER_PRE',lv_legislative_param);
178: l_gre_id := pay_core_utils.get_parameter('TRANSFER_GRE',lv_legislative_param);
179: if (l_gre_id is not null) then