DBA Data[Home] [Help]

APPS.PAY_CA_PAYRG_PKG dependencies on PER_ASSIGNMENTS_F

Line 81: per_assignments_f asg,

77: /* pay reg code */
78:
79: sqlstr := 'select distinct asg.person_id
80: from pay_assignment_actions act,
81: per_assignments_f asg,
82: pay_payroll_actions ppa2, /* run and quickpay payroll actions */
83: pay_assignment_actions act2, /* run and quickpay assignment actions */
84: pay_action_interlocks pai, /* interlocks table */
85: pay_payroll_actions ppa, /* PYUGEN information */

Line 143: per_assignments_f paf,

139: ppa.action_type,
140: ppa.effective_date,
141: act.source_action_id
142: from pay_assignment_actions act,
143: per_assignments_f paf,
144: pay_payroll_actions ppa, /* pre-payments and reversals
145: payroll action id */
146: pay_payroll_actions ppa1, /* PYUGEN payroll action id */
147: pay_all_payrolls_f ppf