APPS.PAY_PAYRG_PKG dependencies on PAY_PAYROLLS_F

Line 176: l_payroll_text := 'and pa1.payroll_id in (select payroll_id from pay_payrolls_f)';

172:
173: /* if l_consolidation_set_id is not null then
174: l_payroll_text := null;
175: else
176: l_payroll_text := 'and pa1.payroll_id in (select payroll_id from pay_payrolls_f)';
177: end if;
178: */
179: END IF;
180:

Line 190: pay_payrolls_f ppf

186: from pay_payroll_actions ppa,
187: pay_payroll_actions pa1,
188: pay_assignment_actions act,
189: per_assignments_f asg,
190: pay_payrolls_f ppf
191: where ppa.payroll_action_id = :payroll_action_id
192: '||l_consolidation_set_text||'
193: '||l_payroll_text||'
194: and pa1.effective_date between ppa.start_date

Line 260: from pay_payrolls_f ppf, -- Bug 3372747

256: ppa.action_type,
257: ppa.effective_date,
258: act.source_action_id,
259: nvl(ppa.start_date,ppa.effective_date)
260: from pay_payrolls_f ppf, -- Bug 3372747
261: pay_payroll_actions ppa, /* pre-payments and reversals
262: payroll action id */
263: pay_assignment_actions act,
264: per_assignments_f paf

Line 325: PAY_PAYROLLS_F PPF

321: HR_ASSIGNMENT_SET_AMENDMENTS HASA ,
322: PER_ASSIGNMENTS_F PAF ,
323: PAY_ASSIGNMENT_ACTIONS ACT ,
324: PAY_PAYROLL_ACTIONS PPA ,
325: PAY_PAYROLLS_F PPF
326: where (c_payroll_id is NULL
327: or ppa.payroll_id = c_payroll_id)
328:
329: and ppa.consolidation_set_id +0 = nvl(c_consolidation_set_id,

Line 439: from pay_payrolls_f ppf,

435:
436: cursor c_payroll_def (cp_assignment_id in number,
437: cp_effective_date in date) is
438: select multi_assignments_flag
439: from pay_payrolls_f ppf,
440: per_assignments_f paf
441: where paf.payroll_id = ppf.payroll_id
442: and cp_effective_date between paf.effective_start_date
443: and paf.effective_end_date