APPS.HRENTMNT dependencies on PAY_PAYROLLS_F

Line 801: from pay_payrolls_f pay

797: into v_check_failed
798: from sys.dual
799: where exists
800: (select null
801: from pay_payrolls_f pay
802: where pay.payroll_id = p_payroll_id
803: and p_validation_end_date >
804: (select max(pay2.effective_end_date)
805: from pay_payrolls_f pay2

Line 805: from pay_payrolls_f pay2

801: from pay_payrolls_f pay
802: where pay.payroll_id = p_payroll_id
803: and p_validation_end_date >
804: (select max(pay2.effective_end_date)
805: from pay_payrolls_f pay2
806: where pay2.payroll_id = pay.payroll_id));
807: --
808: if v_check_failed = 'Y' then
809: hr_utility.set_message(801,'HR_6590_ASS_PYRLL_NOT_EXIST');

Line 7903: pay_payrolls_f p

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 =
7907: v_ppm.org_payment_method_id

Line 7936: pay_payrolls_f p

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 =
7940: v_ppm.org_payment_method_id

Line 7949: pay_payrolls_f p2

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 >
7953: opmu.effective_end_date