DBA Data[Home] [Help]

APPS.PAY_NO_EMP_CONT_2007 dependencies on STANDARD

Line 89: and prt.RUN_TYPE_NAME IN ('Main','Standard','Process Alone','Pay Separately')

85: from pay_payroll_actions ppa
86: ,pay_run_types_f prt
87: where ppa.RUN_TYPE_ID = prt.RUN_TYPE_ID
88: and prt.LEGISLATION_CODE = 'NO'
89: and prt.RUN_TYPE_NAME IN ('Main','Standard','Process Alone','Pay Separately')
90: and p_date_earned between prt.EFFECTIVE_START_DATE and prt.EFFECTIVE_END_DATE
91: and ppa.effective_date between trunc(Add_months(p_date_earned,MOD(TO_NUMBER(TO_CHAR(p_date_earned,'MM')),2)-1),'MM')
92: and last_day(Add_months(p_date_earned,MOD(TO_NUMBER(TO_CHAR(p_date_earned,'MM')),2)));
93: