DBA Data[Home] [Help]

APPS.PAY_RETRO_NOTIF_PKG dependencies on PER_TIME_PERIODS

Line 437: per_time_periods ptp

433: USE_NL(paa ppa) */
434: ''
435: from pay_assignment_actions paa,
436: pay_payroll_actions ppa,
437: per_time_periods ptp
438: where ppa.payroll_action_id = paa.payroll_action_id
439: and paa.assignment_id = pee.assignment_id
440: and paa.action_status not in ('E', 'M', 'U')
441: and ppa.action_type in ('R', 'Q', 'B', 'V')

Line 510: per_time_periods ptp

506: AND pee.effective_end_date >= cp_min_ed
507: AND exists (select ''
508: from pay_assignment_actions paa,
509: pay_payroll_actions ppa,
510: per_time_periods ptp
511: where ppa.payroll_action_id = paa.payroll_action_id
512: and paa.assignment_id = pee.assignment_id
513: and paa.action_status not in ('E', 'M', 'U')
514: and ppa.action_type in ('R', 'Q', 'B', 'V')

Line 588: per_time_periods ptp

584: AND pee.effective_end_date >= cp_min_ed
585: AND exists (select ''
586: from pay_assignment_actions paa,
587: pay_payroll_actions ppa,
588: per_time_periods ptp
589: where ppa.payroll_action_id = paa.payroll_action_id
590: and paa.assignment_id = pee.assignment_id
591: and paa.action_status not in ('E', 'M', 'U')
592: and ppa.action_type in ('R', 'Q', 'B', 'V')