3364: BEGIN
3365:
3366: SELECT puci.value
3367: INTO vBalName
3368: FROM pay_user_column_instances_f puci
3369: WHERE puci.user_row_id=v_csr_get_rows.user_row_id
3370: AND puci.user_column_id=vBalColId
3371: AND p_effective_date between puci.effective_start_date and puci.effective_end_date;
3372:
3383: BEGIN
3384:
3385: SELECT puci.value
3386: INTO vTagName
3387: FROM pay_user_column_instances_f puci
3388: WHERE puci.user_row_id=v_csr_get_rows.user_row_id
3389: AND puci.user_column_id=vTagColId
3390: AND p_effective_date between puci.effective_start_date and puci.effective_end_date;
3391: