DBA Data[Home] [Help]

APPS.PAY_CA_PAYRG_PKG dependencies on PER_ASSIGNMENTS_F

Line 76: per_assignments_f asg,

72: /* pay reg code */
73:
74: sqlstr := 'select distinct asg.person_id
75: from pay_assignment_actions act,
76: per_assignments_f asg,
77: pay_payroll_actions ppa2, /* run and quickpay payroll actions */
78: pay_assignment_actions act2, /* run and quickpay assignment actions */
79: pay_action_interlocks pai, /* interlocks table */
80: pay_payroll_actions ppa, /* PYUGEN information */

Line 138: per_assignments_f paf,

134: ppa.action_type,
135: ppa.effective_date,
136: act.source_action_id
137: from pay_assignment_actions act,
138: per_assignments_f paf,
139: pay_payroll_actions ppa, /* pre-payments and reversals
140: payroll action id */
141: pay_payroll_actions ppa1, /* PYUGEN payroll action id */
142: pay_all_payrolls_f ppf