APPS.HRENTMNT dependencies on PAY_PAYROLLS_F

Line 953: from pay_payrolls_f pay

949: into v_check_failed
950: from sys.dual
951: where exists
952: (select null
953: from pay_payrolls_f pay
954: where pay.payroll_id = p_payroll_id
955: and p_validation_end_date >
956: (select max(pay2.effective_end_date)
957: from pay_payrolls_f pay2

Line 957: from pay_payrolls_f pay2

953: from pay_payrolls_f pay
954: where pay.payroll_id = p_payroll_id
955: and p_validation_end_date >
956: (select max(pay2.effective_end_date)
957: from pay_payrolls_f pay2
958: where pay2.payroll_id = pay.payroll_id));
959: --
960: if v_check_failed = 'Y' then
961: hr_utility.set_message(801,'HR_6590_ASS_PYRLL_NOT_EXIST');

Line 6880: pay_payrolls_f p

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

Line 6913: pay_payrolls_f p

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

Line 6926: pay_payrolls_f p2

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