DBA Data[Home] [Help]

APPS.PAY_HXC_DEPOSIT_INTERFACE dependencies on PAY_NET_CALCULATION_RULES

Line 1063: FROM PAY_NET_CALCULATION_RULES pnt,PAY_INPUT_VALUES_F piv

1059: cursor c_check_pto (p_bg_id NUMBER,p_element_type_id NUMBER,p_effective_date IN DATE)
1060: IS
1061: SELECT pnt.DATE_INPUT_VALUE_id DATE_INPUT_VALUE_id,
1062: pnt.accrual_plan_id accrual_plan_id
1063: FROM PAY_NET_CALCULATION_RULES pnt,PAY_INPUT_VALUES_F piv
1064: WHERE piv.business_group_id=p_bg_id
1065: and pnt.DATE_INPUT_VALUE_id=piv.INPUT_VALUE_ID
1066: and piv.element_type_ID=p_element_type_id
1067: AND p_effective_date between piv.effective_start_date and piv.effective_end_date