eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NO_PAYPROC dependencies on FND_DATE

Line 93: AND pa2.effective_date between fnd_date.canonical_to_date(nvl(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'START_DATE'),

89: AND pa2.payroll_id = p_payroll_id
90: -- and asg.payroll_id = p_payroll_id
91:
92: AND pa2.consolidation_set_id = PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'CONSOLIDATION_SET_ID')
93: AND pa2.effective_date between fnd_date.canonical_to_date(nvl(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'START_DATE'),
94: fnd_date.date_to_canonical(to_date('01/01/1001','DD/MM/YYYY'))))
95: and pa1.effective_date
96: AND pa2.action_type IN ('U','P') -- Prepayments or Quickpay Prepayments
97: AND act.payroll_action_id = pa2.payroll_action_id

Line 94: fnd_date.date_to_canonical(to_date('01/01/1001','DD/MM/YYYY'))))

90: -- and asg.payroll_id = p_payroll_id
91:
92: AND pa2.consolidation_set_id = PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'CONSOLIDATION_SET_ID')
93: AND pa2.effective_date between fnd_date.canonical_to_date(nvl(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'START_DATE'),
94: fnd_date.date_to_canonical(to_date('01/01/1001','DD/MM/YYYY'))))
95: and pa1.effective_date
96: AND pa2.action_type IN ('U','P') -- Prepayments or Quickpay Prepayments
97: AND act.payroll_action_id = pa2.payroll_action_id
98: AND act.action_status IN ('C','S') -- 10229512