DBA Data[Home] [Help]

APPS.PAY_ARCHIVE_MISSING_ASG_PKG dependencies on PAY_PAYROLLS_F

Line 87: pay_payrolls_f ppf,

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
91: AND puar.tax_unit_id = cp_tax_unit_id

Line 135: pay_payrolls_f ppf,

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
139: AND paf.assignment_id = puar.assignment_id

Line 407: pay_payrolls_f ppf

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
411: AND ppa.payroll_action_id = paa.payroll_action_id