DBA Data[Home] [Help]

APPS.PAY_NO_EMP_CONT dependencies on STANDARD

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

117: from pay_payroll_actions ppa
118: ,pay_run_types_f prt
119: where ppa.RUN_TYPE_ID = prt.RUN_TYPE_ID
120: and prt.LEGISLATION_CODE = 'NO'
121: and prt.RUN_TYPE_NAME IN ('Main','Standard','Process Alone','Pay Separately')
122: and p_date_earned between prt.EFFECTIVE_START_DATE and prt.EFFECTIVE_END_DATE
123: and ppa.effective_date between trunc(Add_months(p_date_earned,MOD(TO_NUMBER(TO_CHAR(p_date_earned,'MM')),2)-1),'MM')
124: and last_day(Add_months(p_date_earned,MOD(TO_NUMBER(TO_CHAR(p_date_earned,'MM')),2)));
125: