DBA Data[Home] [Help]

APPS.HRENTMNT dependencies on PAY_ORG_PAY_METHOD_USAGES_F

Line 6879: from pay_org_pay_method_usages_f opmu,

6875: into no_opmu
6876: from sys.dual
6877: where not exists
6878: (select null
6879: from pay_org_pay_method_usages_f opmu,
6880: pay_payrolls_f p
6881: where v_ppm.start_date between opmu.effective_start_date
6882: and opmu.effective_end_date
6883: and opmu.org_payment_method_id =

Line 6912: from pay_org_pay_method_usages_f opmu,

6908: into no_opmu
6909: from sys.dual
6910: where exists
6911: (select null
6912: from pay_org_pay_method_usages_f opmu,
6913: pay_payrolls_f p
6914: where opmu.effective_start_date <= v_ppm.end_date
6915: and opmu.effective_end_date >= v_ppm.start_date
6916: and opmu.org_payment_method_id =

Line 6925: from pay_org_pay_method_usages_f opmu2,

6921: and p.payroll_id = p_payroll_id
6922: and opmu.effective_end_date < v_ppm.end_date
6923: and not exists
6924: (select null
6925: from pay_org_pay_method_usages_f opmu2,
6926: pay_payrolls_f p2
6927: where opmu2.effective_start_date <=
6928: opmu.effective_end_date + 1
6929: and opmu2.effective_end_date >