DBA Data[Home] [Help]

APPS.PER_IE_ORG_INFO dependencies on PAY_ALL_PAYROLLS_F

Line 286: pay_all_payrolls_f pap,

282: select 1
283: from dual
284: where exists(select NULL
285: from per_all_assignments_f paa,
286: pay_all_payrolls_f pap,
287: hr_soft_coding_keyflex scl
288: where paa.payroll_id = pap.payroll_id
289: and p_effective_date not between paa.effective_start_date and paa.effective_end_date
290: and paa.assignment_id = p_assignment_id

Line 303: ,pay_all_payrolls_f pay

299: p_business_group_id number,
300: p_effective_date date) is
301: select sck.segment4
302: from hr_soft_coding_keyflex sck
303: ,pay_all_payrolls_f pay
304: where pay.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
305: and pay.payroll_id = p_payroll_id
306: and P_EFFECTIVE_DATE between pay.effective_start_date and pay.effective_end_date
307: and pay.business_group_id=p_business_group_id;