APPS.PAY_ARCHIVE_MISSING_ASG_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 40: from pay_payroll_actions

36: hr_utility.trace('PACTID = '||to_char(pactid));
37:
38: select legislative_parameters
39: into lv_legislative_param
40: from pay_payroll_actions
41: where payroll_action_id = pactid;
42:
43: sqlstr := 'SELECT distinct ASG.person_id
44: FROM per_all_assignments_f ASG,

Line 46: pay_payroll_actions PPA

42:
43: sqlstr := 'SELECT distinct ASG.person_id
44: FROM per_all_assignments_f ASG,
45: pay_us_asg_reporting PUAR,
46: pay_payroll_actions PPA
47: WHERE PPA.payroll_action_id = :payroll_action_id
48: AND PUAR.tax_unit_id = pay_us_payroll_utils.get_parameter(
49: ''TRANSFER_GRE'',
50: legislative_parameters)

Line 86: pay_payroll_actions ppa,

82: SELECT distinct paf.assignment_id asg_id,
83: paa.assignment_action_id assact
84: FROM per_all_assignments_f paf,
85: pay_assignment_actions paa,
86: pay_payroll_actions ppa,
87: pay_payrolls_f ppf,
88: pay_us_asg_reporting puar
89: WHERE paf.assignment_id = paa.assignment_id
90: AND paf.assignment_id = puar.assignment_id

Line 106: FROM pay_payroll_actions ppa,

102: AND ppf.payroll_id >= 0
103: AND paa.tax_unit_id = cp_tax_unit_id
104: AND paf.person_id between cp_start_person_id and cp_end_person_id
105: AND not exists (SELECT 1
106: FROM pay_payroll_actions ppa,
107: pay_assignment_actions paa
108: WHERE ppa.report_type = 'YREND'
109: AND ppa.action_status = 'C'
110: AND ppa.effective_date = cp_year_end

Line 134: pay_payroll_actions ppa,

130: SELECT distinct paf.assignment_id asg_id,
131: paa.assignment_action_id assact
132: FROM per_all_assignments_f paf,
133: pay_assignment_actions paa,
134: pay_payroll_actions ppa,
135: pay_payrolls_f ppf,
136: pay_us_asg_reporting puar,
137: pay_population_ranges ppr
138: WHERE paf.assignment_id = paa.assignment_id

Line 158: FROM pay_payroll_actions ppa,

154: AND ppf.payroll_id >= 0
155: AND paa.tax_unit_id = cp_tax_unit_id
156: AND paf.person_id between cp_start_person_id and cp_end_person_id
157: AND not exists (SELECT 1
158: FROM pay_payroll_actions ppa,
159: pay_assignment_actions paa
160: WHERE ppa.report_type = 'YREND'
161: AND ppa.action_status = 'C'
162: AND ppa.effective_date = cp_year_end

Line 194: from pay_payroll_actions

190: 'TRANSFER_GRE',
191: legislative_parameters)
192: into g_effective_date,
193: g_tax_unit_id
194: from pay_payroll_actions
195: where payroll_action_id = pactid;
196:
197: l_year_start := trunc(g_effective_date, 'Y');
198: l_year_end := add_months(trunc(g_effective_date, 'Y'),12) -1;

Line 327: from pay_payroll_actions ppa

323: into l_param,
324: l_business_group_id,
325: l_start_date,
326: l_end_date
327: from pay_payroll_actions ppa
328: where ppa.payroll_action_id = p_payroll_action_id;
329:
330: l_step := 2;
331: open c_get_leg_code(l_business_group_id);

Line 406: pay_payroll_actions ppa,

402: FROM pay_run_results prr,
403: pay_run_result_values prrv,
404: pay_input_values_f piv,
405: pay_assignment_actions paa,
406: pay_payroll_actions ppa,
407: pay_payrolls_f ppf
408: WHERE paa.assignment_id = cp_assignment_id
409: AND paa.tax_unit_id = cp_tax_unit_id
410: AND prr.assignment_Action_id = paa.assignment_Action_id

Line 442: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

438: lv_result_value number:=0;
439: lv_count number;
440: l_asgid pay_assignment_actions.assignment_id%TYPE;
441: l_chunk number;
442: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
443: lv_session_id number;
444: l_step number;
445:
446: begin

Line 552: from pay_payroll_actions

548: pay_us_payroll_utils.get_parameter('TRANSFER_GRE',
549: legislative_parameters)
550: into g_effective_date,
551: g_tax_unit_id
552: from pay_payroll_actions
553: where payroll_action_id = p_payroll_action_id;
554: --
555: hr_utility.trace('entering archive_deinit');
556: --