DBA Data[Home] [Help]

APPS.PAY_HXC_DEPOSIT_INTERFACE dependencies on PAY_NET_CALCULATION_RULES

Line 1037: FROM PAY_NET_CALCULATION_RULES pnt,PAY_INPUT_VALUES_F piv

1033: cursor c_check_pto (p_bg_id NUMBER,p_element_type_id NUMBER,p_effective_date IN DATE)
1034: IS
1035: SELECT pnt.DATE_INPUT_VALUE_id DATE_INPUT_VALUE_id,
1036: pnt.accrual_plan_id accrual_plan_id
1037: FROM PAY_NET_CALCULATION_RULES pnt,PAY_INPUT_VALUES_F piv
1038: WHERE piv.business_group_id=p_bg_id
1039: and pnt.DATE_INPUT_VALUE_id=piv.INPUT_VALUE_ID
1040: and piv.element_type_ID=p_element_type_id
1041: AND p_effective_date between piv.effective_start_date and piv.effective_end_date