DBA Data[Home] [Help]

APPS.HRENTMNT dependencies on PAY_ORG_PAY_METHOD_USAGES_F

Line 7902: from pay_org_pay_method_usages_f opmu,

7898: into no_opmu
7899: from sys.dual
7900: where not exists
7901: (select null
7902: from pay_org_pay_method_usages_f opmu,
7903: pay_payrolls_f p
7904: where v_ppm.start_date between opmu.effective_start_date
7905: and opmu.effective_end_date
7906: and opmu.org_payment_method_id =

Line 7935: from pay_org_pay_method_usages_f opmu,

7931: into no_opmu
7932: from sys.dual
7933: where exists
7934: (select null
7935: from pay_org_pay_method_usages_f opmu,
7936: pay_payrolls_f p
7937: where opmu.effective_start_date <= v_ppm.end_date
7938: and opmu.effective_end_date >= v_ppm.start_date
7939: and opmu.org_payment_method_id =

Line 7948: from pay_org_pay_method_usages_f opmu2,

7944: and p.payroll_id = p_payroll_id
7945: and opmu.effective_end_date < v_ppm.end_date
7946: and not exists
7947: (select null
7948: from pay_org_pay_method_usages_f opmu2,
7949: pay_payrolls_f p2
7950: where opmu2.effective_start_date <=
7951: opmu.effective_end_date + 1
7952: and opmu2.effective_end_date >