DBA Data[Home] [Help]

APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PER_TIME_PERIODS

Line 620: l_value PER_TIME_PERIODS.PRD_INFORMATION2%TYPE;

616: /* Added to support override for Use of Holiday Card for transfer to Holiday Bank for bug fix 5533140*/
617: FUNCTION get_use_hol_card(p_payroll_action_id NUMBER,p_date_earned DATE ) RETURN VARCHAR2
618: IS
619:
620: l_value PER_TIME_PERIODS.PRD_INFORMATION2%TYPE;
621: l_payroll_id NUMBER;
622:
623: /* Modified the cursor for bug 5533140*/
624:

Line 658: , per_time_periods TPERIOD

654: Select
655: TPTYPE.number_per_fiscal_year
656: from
657: pay_payroll_actions PACTION
658: , per_time_periods TPERIOD
659: , per_time_period_types TPTYPE
660: where PACTION.payroll_action_id = p_payroll_action_id
661: and TPERIOD.payroll_id = PACTION.payroll_id
662: and p_date_earned between TPERIOD.start_date and TPERIOD.end_date