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 590: per_time_periods ptp

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

Line 789: from per_time_periods

785: hr_utility.trace('The payroll id is '||l_payroll_id_ear_date);
786:
787: select start_date
788: into l_min_run_ear_date
789: from per_time_periods
790: where l_min_ear_date_ptp between start_date and end_date
791: and payroll_id = l_payroll_id_ear_date;
792:
793: hr_utility.trace('The start date finally calculated is '||l_min_run_ear_date);

Line 815: from per_time_periods

811: hr_utility.trace('The payroll id wrt eff date is '||l_payroll_id_eff_date);
812:
813: select start_date
814: into l_min_run_eff_date
815: from per_time_periods
816: where l_min_eff_date_ptp between start_date and end_date
817: and payroll_id = l_payroll_id_eff_date;
818:
819: hr_utility.trace('The start date wrt effective date finally calculated is '||l_min_run_eff_date);