APPS.PAY_MX_PAYREG_PKG dependencies on PAY_PAYROLLS_F

Line 121: pay_payrolls_f ppf

117: FROM pay_payroll_actions ppa,
118: pay_payroll_actions pa1,
119: pay_assignment_actions act,
120: per_assignments_f asg,
121: pay_payrolls_f ppf
122: WHERE ppa.payroll_action_id = :payroll_action_id
123: '||l_consolidation_set_text||'
124: '||l_payroll_text||'
125: and pa1.effective_date between ppa.start_date

Line 193: FROM pay_payrolls_f ppf,

189: ppa.action_type,
190: ppa.effective_date,
191: act.source_action_id,
192: nvl(ppa.start_date,ppa.effective_date)
193: FROM pay_payrolls_f ppf,
194: pay_payroll_actions ppa, /* pre-payments and reversals
195: payroll action id */
196: pay_assignment_actions act,
197: per_assignments_f paf

Line 254: pay_payrolls_f ppf

250: FROM hr_assignment_set_amendments hasa ,
251: per_assignments_f paf ,
252: pay_assignment_actions act ,
253: pay_payroll_actions ppa ,
254: pay_payrolls_f ppf
255: WHERE (c_payroll_id IS NULL
256: OR ppa.payroll_id = c_payroll_id)
257: AND ppa.consolidation_set_id +0 = nvl(c_consolidation_set_id,
258: ppa.consolidation_set_id)

Line 363: FROM pay_payrolls_f ppf,

359:
360: CURSOR c_payroll_def (cp_assignment_id IN NUMBER
361: ,cp_effective_date IN DATE) IS
362: SELECT multi_assignments_flag
363: FROM pay_payrolls_f ppf,
364: per_assignments_f paf
365: WHERE paf.payroll_id = ppf.payroll_id
366: AND cp_effective_date BETWEEN paf.effective_start_date
367: AND paf.effective_end_date

Line 1015: ,pay_payrolls_f ppf

1011: SELECT ppf.payroll_name
1012: ,pcs.consolidation_set_name
1013: FROM pay_payroll_actions ppa
1014: ,pay_assignment_actions paa
1015: ,pay_payrolls_f ppf
1016: ,pay_consolidation_sets pcs
1017: WHERE ppa.payroll_action_id = paa.payroll_action_id
1018: AND ppa.payroll_id = ppf.payroll_id
1019: AND ppa.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date

Line 1650: ,pay_payrolls_f ppf

1646: hr_utility.set_location ('Entering '||l_proc_name ,20);
1647: SELECT ppf.payroll_name||' '||papf.full_name
1648: INTO return_val
1649: FROM per_all_assignments_f paf
1650: ,pay_payrolls_f ppf
1651: ,per_all_people_f papf
1652: WHERE paf.payroll_id = ppf.payroll_id
1653: AND c_effective_date BETWEEN
1654: paf.effective_start_date AND paf.effective_end_date