APPS.PAY_GB_MULTI_DML_AND_VAL dependencies on PAY_ALL_PAYROLLS_F

Line 42: FROM PAY_ALL_PAYROLLS_F WHERE

38: FROM PAY_GB_PAYROLL_GROUPS WHERE
39: PAYROLL_GROUP_ID =P_PAYROLL_GROUP_ID;
40:
41: SELECT distinct PERIOD_TYPE INTO P_FREQUENCY
42: FROM PAY_ALL_PAYROLLS_F WHERE
43: PAYROLL_ID=P_PAYROLL_ID;
44:
45: IF P_FREQUENCY = G_FREQUENCY THEN
46: V_STATUS:=1;

Line 272: FROM PAY_ALL_PAYROLLS_F PAPF

268: hr_utility.trace(P_PAYROLL_GROUP_ID);
269: hr_utility.trace(P_BUSINESS_GROUP_ID);
270:
271: SELECT PAPF.PAYROLL_NAME INTO V_PAYROLL_NAME
272: FROM PAY_ALL_PAYROLLS_F PAPF
273: WHERE PAPF.PAYROLL_ID=P_PAYROLL_ID
274: AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
275: AND PAPF.BUSINESS_GROUP_ID=P_BUSINESS_GROUP_ID;
276: