APPS.HR_NO_UTILITY dependencies on PER_TIME_PERIODS

Line 769: from PER_TIME_PERIODS

765: /* l_start_date is the modified element entry effective start date when the payroll changes year*/
766:
767: Select COUNT(*)
768: INTO l_num_of_periods
769: from PER_TIME_PERIODS
770: where PAYROLL_ID=p_payroll_id
771: and REGULAR_PAYMENT_DATE <> p_start_date
772: and REGULAR_PAYMENT_DATE between l_start_date and p_end_date
773: and REGULAR_PAYMENT_DATE <= to_date('31-12-' || to_char(p_curr_pay_start_date,'RRRR'),'DD-MM-RRRR');

Line 808: from PER_TIME_PERIODS

804: BEGIN
805:
806: Select COUNT(*)
807: INTO l_num_of_periods
808: from PER_TIME_PERIODS
809: where PAYROLL_ID=p_payroll_id
810: and to_char(REGULAR_PAYMENT_DATE,'mm-yyyy') = to_char(p_curr_per_pay_date,'mm-yyyy');
811:
812: EXCEPTION

Line 839: from PER_TIME_PERIODS

835: BEGIN
836:
837: Select REGULAR_PAYMENT_DATE
838: INTO l_regular_pay_date
839: from PER_TIME_PERIODS
840: where PAYROLL_ID=p_payroll_id
841: and START_DATE = p_Curr_Pay_Start_Date;
842:
843: EXCEPTION